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. |
Installation of SQL Server 2019
POA for SQL Server In-Place Up-gradation
How to Move TempDB from one drive to another drive
