August 6, 2003 at 6:47 am
Hi All,
On my production servers I have log shipping and all the databases are out of sync today. Till yesterday everything was fine, and we did not change anything on the server.
In the properties of all the monitors I see the copy and load delta as a negative number.
Any help is appreciated.
Thanks.
Edited by - ranec on 08/06/2003 06:58:58 AM
August 6, 2003 at 7:06 am
If all databases are out of sync then it sounds like a prolonged network outage overnight. You may have to manually resync the databases from full backups (WITH NORECOVERY)
Cheers,
- Mark
Cheers,
- Mark
August 6, 2003 at 7:12 am
Even I thought so, and backuped but the databases and restored it on destination server with norecovery. Then I backed up the transaction log, ran the copy and restore jobs. Everything was fine. All the jobs were succesfull but the database is still "out of sync" and still showing nevegative number as copy and load delta.
Please help.
August 6, 2003 at 7:19 am
Are the times on the servers in sync?
Cheers,
- Mark
Cheers,
- Mark
August 6, 2003 at 7:36 am
Actually one of my co-workers just admited that he messed with the log_shipping_monitor table in msdb database and he made it to point it to wrong server, thats the reason why I was seeing these things. Sorry about that.
And thanks for your prompt response.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply