Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-17 : 08:38:10
|
| Raj writes "Hey ,while log shiping my production server went down and i needed to reboot it, when it came up and my log shipping gaves me error thet file is currupted, My team member has suggetsed me to skip that perticular file and take next one ?/my question will that be possible? how ? please explainn me .Raj" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-03-17 : 08:42:09
|
| This most likely won't work because the next log won't have the right LSN in sequence. It won't hurt to try since it's already broken but I think you're out of luck. If it's feasable to do, you might just try backing up your production db, dropping the log shipped version and then restoring over it so log shipping can start over. You shouldn't need to rebuild your jobs once you've done this.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
log shipping