Migration Checklist summary

Pre-Migration Checklist

1.       Analyze the disk space of the target server for the new database, if the disk space is not enough add more space on the target server

2.       Confirm the data and log file location for the target server

3.       Collect the information about the Database properties (Auto Stats, DB Owner, Recovery Model, Compatibility level, Trustworthy option etc)

4.       Collect the information of dependent applications, make sure application services will be stopped during the database migration

5.       Collect the information of database logins, users and their permissions. (Optional)

6.       Check the database for the Orphan users if any

7.       Check the SQL Server for any dependent objects (SQL Agent Jobs and Linked Servers)

8.       Check, if the database is part of any maintenance plan

9.       Database Migration Checklist

These are the steps you would go through to make the change.

1.       Stop the application services

2.       Change the database to read-only mode (Optional)

3.       Take the latest backup of all the databases involved in migration

4.       Restore the databases on the target server on the appropriate drives

5.       Cross check the database properties as per the database property script output, change the database properties as per the pre migration- checklist

6.       Execute the output of Login transfer script on the target server, to create logins on the target server you can get the code from this technet article: http://support.microsoft.com/kb/246133.

2.       Check for Orphan Users and Fix Orphan Users

3.       Run the DBCC UPDATEUSAGE command against the migrated database when upgrading to a newer version of SQL Server.

4.       Rebuild Indexes (Optional) As per the requirement and time window you can execute this option.

5.       Update index statistics

6.       Recompile procedures

7.       Start the application services, check the application functionality and check the Windows event logs.