SQL DBA Tutorial

POA for Log Shipping Creation

POA for Log Shipping creation
POA for Log Shipping Creation
Implementation Plan
S.NO  Activity Steps
1 Take Full backup of all the databases in Primary server
2 Move the backup files to Secondary server.
3 Create a shared folders on both servers with read and write permissions.
4 Restore the Full backup of user databases on Secondary server with no-recovery,
5 Take Transaction log backup of databases in Primary server.
6 Move the Transaction log backup files to DR server.
7 Restore the Transaction log backups of user databases in DR server with no-recovery.
8 Enable the log shipping between Production server to DR server.
9 Check the database functionality.
Roll backward Plan
S.NO  Activity Steps
1 Break the log shipping between Production server to DR server.
2 Bring the databases online on DR server post breaking configuration.
3 Check the database functionality.

Get SQL Dba Tutorial Updates!

Signup now and receive an email once I publish new content.

Thank you for subscribing.
Something went wrong.
I agree to have my personal information transfered to MailChimp ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Exit mobile version