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).