Pre-Check list to Migrate SQL Server

• Took the Databases Back Up from old server and moved Backups to New Servers.
• Installation SQL Server on server.
• Restored Databases
• Changed DB owner to SA
• Transferred Logins to new server from old server.
• changed Database Compatibility Level.
• Move jobs to server.
• Move linked servers if any.
• complete DBCC CHECKDB WITH DATA_PURITY (Checks for invalid data values based on column data type).
• Update Statistics (sp_updatestats) (Brings database statistics are up to date to allow the query optimizer to choose the best query plan, take a Full Backup of the Database, make sure you can recover the database with all of the migration efforts)

Checklist to configure SQL Server Database Mirroring.

Checklist to configure SQL Server Database Mirroring.

1. Enable SQL TCP and UDP(for Named instances) in firewall.
2. Start MSSQLSERVER Services with Domain user credentials (instead of Local System Account) on principal database Server and Mirror Database Server.
3. Enable DB mirror Ports in Firewall (Principal, Mirror and Witness).
4. principal DB should be FULL Recover model.
5. Take latest full backup and Logbackup.
6. Restore full and Log backup with no recovery option.
7. The end point should have the status started.