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. |