Friday, April 17, 2020

Reverse Log shipping Setup

1.) Disable all shipping Logshipping jobs.

 2.) Wait to complete all active transactions to complete.

3.) GO TO primary server and take log backup with no recovery command:-

Backup log DB to disk='d:\DB.trn' with norecovery 

4.) Manually run copy job.

5.) Manually run restore job.

6.) Go to secondary Server and restore log backup that we took in step 3 with NORecovery option:-

 Use [Master]
 Restore log db from disk='d:\DB.trn' with recovery

 7.) Configure logshipping again