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)
 Log Shipping resync

Author  Topic 

Westley
Posting Yak Master

229 Posts

Posted - 2005-10-01 : 23:55:46
Hi,
I'm just wondering, apart from recreating log shipping tasks (using standard maintenance task), is there any other way to resync log shipping which already running (created via maintenance task), what I wanted to do is ask it to perform a check (is there such thing like replication where it can do a row check?) or it just make a new backup from the source DB and copy-restore the new backup to the dest server to make sure everything are in sync, the reason for that is the log shipping reported it failed for some time, and I have stopped it for 2 hrs and restarting it again, I would like to make sure the dest DBs are in sync with the source, what will be the best way to perform these checks? as I don't want to delete them and creating them again.
Thanks,
   

- Advertisement -