dbTalk Databases Forums  

Log Shipping out-of-sync

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Log Shipping out-of-sync in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andreas
 
Posts: n/a

Default Log Shipping out-of-sync - 07-17-2003 , 04:02 AM






I have the following senario:
2 servers part of Log Shipping. Many databases from the Primary Server are
being log-shipped to the stand-by server with no recovery option. All
maintetance plans have been designed with exactly the same options, timeouts
and thresholds. However, two of those dbs on the standby server always get
out-of-sync. By reviewing the logs, I notice that at a point in time, I
start having 2 consequent logs that wait to be restored meaning that the
first of the 2 was not restored when it was supposed to do so. The errors
afterwards is that it cannot restore such old logs.

Another clue that I discovered is that this problem starts at a time that
this database is being heavily updated by clients. All the other hours,
updates are
very rare. Is there any type of update to a db that can cause it to come
out-of-sync ?

Please note that I have tried several different values for the backup times
and out-of-sync thresholds but in vain.

Another question: If you use Log Shipping and at the same time you perform
Transaction Log backups, will this affect the log shipping ? (because you
have intermediate logs that are not being replicated to the standby server?)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.