Log Shipping going out-of-sync

Hello everyone:

I wanted to ask a question about log shipping going out of sync. We have a remote server in the UK that is our production server, and we are trying to set up log shipping with another server in the US. Our Log shipping monitor goes "out-of-sync" after about 8-10 hours. We changed the US server to have the same time as the server in the UK, but there still seems to be an out of syn error after 8 hours.

We are using Windows server 2000 and SQL server 2000.

SQL server will restore logs then after a few hours it stops restoring and goes out of sync. Was just wondering if someone knew the possibilities of why.

Thank you.

Hi Bendoke,

I can see your direction to solve the issue sicne the local time difference between UK and US is 8 hours. does the outofsync occurs exactly after 8 hours LS got setup ?

once the outofsync occurs, have you checked the backup/copy/restore job history to see if there is any error ?

regards!

Yunwen

|||

No, the out of sync error occurs 45 minutes after beginning log shipping. When I view the backup/copy/restore history, everything is "successful" I am thinking that the monitor may not be reading something correctly. Someone also mentioned that my anti-virus scan may interfere with this? I do not know if this is accurate or not.

Thank you,

Ben