Log Shipping "Out of Sync" State

I have two production SQL servers that log ship to two
failsafe servers in different geographic locations. I am
continually having "Out of Sync" conditions on one or more
of the databases that are being log shipped. In order to
clear the "Out of Sync" condition, I must blow away the
log shipping maintenance plan, all existing transaction
log backups for the particular database on all servers and
recreate the plans. What can I do to prevent or easily
correct the "Out of Sync" condition? What is the impact of
the "Out of Sync" condition to my failsafe plan? Are the
databases invalid?Log shipping is just the technique of applying a database backup to a =
server and then applying future transaction log backups to the server. =
They can get out of synch when a transaction restore fails to execute =
and another transaction log backup happens and is attempted to be =
applied to the server.
To correct the out of synch errors simply disable your transaction log =
backups, re-run your full database backup, restore to your standby =
server, and then re-enable your transaction log backups (and automated =
restore process)
To prevent this from happening make sure that you have a reliable =
network. You might also want to put some logging/error checking in =
place. If a job fails perhaps you can retry it.
What do you mean by invalid? When this does happen the databases are =
not bad, the log shipped database simply does not contain current data.
Perhaps you will find this additional information helpful:
http://sqlguy.home.comcast.net/logship.htm
--=20
Keith
"Colby" <anonymous@.discussions.microsoft.com> wrote in message =
news:b50b01c4375d$fffeee80$a301280a@.phx.gbl...
> I have two production SQL servers that log ship to two=20
> failsafe servers in different geographic locations. I am=20
> continually having "Out of Sync" conditions on one or more=20
> of the databases that are being log shipped. In order to=20
> clear the "Out of Sync" condition, I must blow away the=20
> log shipping maintenance plan, all existing transaction=20
> log backups for the particular database on all servers and=20
> recreate the plans. What can I do to prevent or easily=20
> correct the "Out of Sync" condition? What is the impact of=20
> the "Out of Sync" condition to my failsafe plan? Are the=20
> databases invalid?