Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log shipping error


Log shipping error

Author
Message
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
Hi All,

while restoring database in secondary server I am getting below error
"row index must be greater than or equal to zero and less than the number of rows. ParameterName: nRowIndex. Actual value was 4(microsoft.sqlserver.Gridcontrol)"

I have searched in so many and they are saying restart the seconadry server instance. I have restarted sql services, but still the error is remain same.

Thanks
Beatrix Kiddo
Beatrix Kiddo
SSC Eights!
SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)

Group: General Forum Members
Points: 963 Visits: 3577
You need to give a bit more information with your questions. Are you doing this manually or as part of the LSRestore job?
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
i am getting error while configuring log shipping in the secondary server. backup has been taken while restoring error is coming
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
Hi All,

I am getting below error while restoring log backup in secondary server.

"Message
2014-06-20 06:04:01.25 Skipped log backup file. Secondary DB: 'OS_Test', File: 'M:\Secondary DB\OS_Test_20140619073534.trn'
2014-06-20 06:04:01.25 Could not find a log backup file that could be applied to secondary database 'OS_Test'.
2014-06-20 06:04:01.26 The restore operation was successful. Secondary Database: 'OS_Test', Number of log backup files restored: 0
2014-06-20 06:04:01.26 Deleting old log backup files. Primary Database: 'OS_Test'."

Everytime Log shipping job is failing. I schedcule job every 24 hours. First day it was running fine but from second day it start giving error. Is there any permanent solution to resolve this issue.

----Thanks in advance----
Beatrix Kiddo
Beatrix Kiddo
SSC Eights!
SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)

Group: General Forum Members
Points: 963 Visits: 3577
Beatrix Kiddo (6/13/2014)
Ok, then something else may well be backing up your database and breaking your log chain (as far as log-shipping is concerned). I'd check that with your sysadmins.

It sounds like they're doing this overnight.

Have you checked this?
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
Yes , log backup is running @ 6:oo AM and full backup is running @8:00 PM
Beatrix Kiddo
Beatrix Kiddo
SSC Eights!
SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)

Group: General Forum Members
Points: 963 Visits: 3577
So you're only taking one log backup a day right before your full backup? Then that "error message" you're getting makes sense, no?
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
what is the solution for that , should i take full backup first and after that if i run log backup then that error message will come , and log shipping will also work fine
arooj300
arooj300
SSC-Enthusiastic
SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)SSC-Enthusiastic (153 reputation)

Group: General Forum Members
Points: 153 Visits: 533
should i stop the tape backup which has scheduled, or I need to change the backup schedule timing.
Beatrix Kiddo
Beatrix Kiddo
SSC Eights!
SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)SSC Eights! (963 reputation)

Group: General Forum Members
Points: 963 Visits: 3577
I don't really understand your backup strategy. Why are you only backing up the log once a day? Did you switch recovery model to Full purely because you wanted to set up log-shipping? If you can explain a bit more about that it will be easier to know what to suggest.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search