Satndby Serverupdate

Hi,
How to make sure all transaction has been updated on standby server in case of log shipping?
Thx
-SeeanIf you are using SQL 2000 to set up Log Shipping, there is a value called the Synch Threshold. The server that is set up to be the monitor server will periodically check the standby server to ensure that:

1. The Backup on the primary server has taken place according to schedule.

2. The transaction log file has been copied from the primary to the standby server

3. The transaction log has been loaded onto the standby server.

In EM for the Log Shipping monitor server, the SQL Agent will also have an entry for Log Shipping Monitor. If any of the three events outlined above has not occurred or is occurring behind schedule, there will be a red 'x' marked for that Log Shipping plan. Note that SQL is not necessarily too smart about where to set the threshold levels. You may need to adjust the threshold values to more closely align with your log shipping backup, copy and restore intervals.

Regards,

Hugh Scott

Originally posted by sqlserverdb
Hi,
How to make sure all transaction has been updated on standby server in case of log shipping?
Thx
-Seean|||You can also check the error log on the standby server and it should say that the Log for the [DB] restored