Sunday, March 25, 2018

Pre-Check list to Migrate SQL Server


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)



No comments:

Post a Comment