Logshipping out of sync

• jamessdba

  SSCrazy

  Points: 2254

  More actions

  October 23, 2014 at 4:56 am

  #294414

  Hi,

  My Logshipping is showing out of sync (sqlserver 2008R2)

  Please provided the steps to analysis & how to fix it

• spaghettidba

  SSC Guru

  Points: 105712

  More actions

  October 23, 2014 at 5:03 am

  #1754288

  First Google result for log shipping out of sync is this article:

  http://blogs.technet.com/b/mdegre/archive/2009/08/11/logshipping-secondary-server-is-out-of-sync-and-lsrestore-job-failing.aspx

  Have you tried any of these steps?

  -- Gianluca Sartori

• Perry Whittle

  SSC Guru

  Points: 233792

  More actions

  October 23, 2014 at 5:11 am

  #1754289

  jamessdba (10/23/2014)

  ---

  Hi,

  My Logshipping is showing out of sync (sqlserver 2008R2)

  Please provided the steps to analysis & how to fix it

  Have you run a full backup on the primary since LS broke?

  Use this query against the primary and then against the secondary to find out if you have

  select name, differential_base_lsn from sys.master_files

  where database_id = db_id('yourdb') and type = 0

  If the differential base lsn matches on both primary and secondary, stop all LS jobs.

  Take a differential backup on the primary and then restore this to the secondary. Now restart all the LS jobs.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉