SQL DBA Tutorial

POA for SQL Database Migration

POA for SQL Database Migration

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

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