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
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
No comments:
Post a Comment