How to resync the existing log shipping setup:

1. Take full backup of Primary database in the primary server.

2. Copy to secondary server database backup location drive.

3. Disable all jobs (Backup job in primary server, Copy and Restore jobs in secondary server)

To change secondary datbase into online.

Restore database secondarydatabasename
With recovery

4. Restore the secondary server database using primary server database backup file with standby /readonly or with norecovery mode.

5. Enable
       ->Backup job first
       ->Copy job Next
       ->Restore job last.

6. View successive schedules for successful job history.

That’s it

Hope you will re configure the existing non-sync log shipping setup into sync mode.


Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)