• 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" 😉