In this article we will explain how to prepare plan of action(POA) for Database Migration from One server to Another server.
POA for Database migrating from One server to Another server | |
Implementation Plan | |
SL.No | Plan of action |
1 | Take full backup of all the databases. |
2 | Take the backup of all the linked servers,Logins,User roles Jobs from source. |
3 | Check the collation level of the instance(Take snap) on source. |
4 | Take backup of sp_configure,sp_helpdb,sys.master_files,sys.databases to an Excel file on source. |
5 | Stop the application. |
8 | Copy backup files from source to destination server. |
11 | Restore the backup in destination servers. |
13 | Replicate Login,Fix orphaned Users,User Roles,restore jobs and linked servers. |
14 | Check the services, configurations, DB accessibility and verify error logs on destination. |
15 | Start the application and check the functionality on destination. |
Rollback Plan | |
SL.No | Plan of action |
1 | Map the application to source server. |
2 | Check the services, configurations, DB accessibility and verify error logs on source . |
3 | Check the application status. |