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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 When Log Shipping Goes Bad

Author  Topic 

mr_mist
Grunnio

1870 Posts

Posted - 2004-06-09 : 03:31:39
Hi

I am just looking in to some possibilities of log shipping problems. One of the scenerios we can see is that a log file somehow is corrupted between source and destination, such as that it cannot be restored to the destination.

If this were the case, how would I go about recovering log shipping without having to take another full backup and starting again? Is there a method?

-------
Moo. :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-09 : 12:24:26
If the tlog is corrupt at both locations, then you would need to redo log shipping starting with a full backup. But chances are that the file is not corrupt at the source, so just recopy it over.

Tara
Go to Top of Page
   

- Advertisement -