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