Groups | Blog | Home
all groups > sql server (alternate) > september 2004 >

sql server (alternate) : log shipping - out of sync



farrellyr NO[at]SPAM yourfuture.ab.ca
9/27/2004 8:41:57 AM
I have tried to set up log shipping for one of our databases - first
time. Using EM I was able to create the job and maintenance plan
sucessfully. I wasn't able to find any errors in any logs. In the
monitor server, when I look at job history, everything is getting
copied and loaded sucessfully, yet the STATUS in the log shipping
monitor states it is out of sync.

How do I get this into sync? I have set the out of sync threshold to
45 minutes. I have made changes in our production database and those
changes are showing up in the standby database, so it all appears to
be working.


Simon Hayes
9/28/2004 11:22:08 AM

[quoted text, click to view]

http://support.microsoft.com/default.aspx?scid=kb;en-us;329133

Simon

AddThis Social Bookmark Button