Wednesday, March 21, 2012

log shipping out of sync

I have set up a database with log shipping to the backup server. I have actually set it up multiple times because it continues to get out of sync, and I do not know another way to get it back in sync (despite much effort to learn how). I have not found much documentation in BOL, nor in the on-line areas that I can find. I have not been able to discover why it keeps getting out of sync.
If there is anyone who may shed some light on this, I would be very greatful.
Particulars (both servers):
Windows ADV Server 2003
SQL 2000 (Enterprise Ed.)
Servers on a work group (not domain)

There is a separate database on the same servers that continues to have successful log shipping.
Thank you very much (in advance).

you can try to manually restore the logs that was not applied to the secondary database, or, restore the latest full backup, and then re-sume logshipping to get your logshipping work again.

Is there anything particular on this configuration? you mentioned that Logshipping with other databases worked successfully on the same server so I assume your configuration of both LS are correct.

Thanks

Yunwen

No comments:

Post a Comment