Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Satndby Serverupdate

    Hi,
    How to make sure all transaction has been updated on standby server in case of log shipping?
    Thx
    -Seean

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Satndby Serverupdate

    If 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

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    You can also check the error log on the standby server and it should say that the Log for the [DB] restored

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •