MSSQL 2005 - 2008 Upgrade Testing

  • Last updated on: 2016-06-21
  • Authored by: Rackspace Support

Note: This article is written for our Cloud Sites Control Panel. You can get to it from the Cloud Control Panel by clicking Rackspace Cloud in the upper-left corner and selecting Cloud Sites. You can also navigate directly to

Pre-Migration Tasks:

If followed correctly, site impact during the migration process should be minimal. With that said, it is highly suggested to perform this migration at a non-peak time to minimize business impact. Here are some tips for database migration:

  1. Set your default page to reflect that your site is currently under maintenance to limit the traffic that would be hitting the database.

  2. Confirm that your current hosting plan has an adequate number of databases allotted. You may need to add additional databases to the plan to perform this migration successfully. If that is the case, review the article: How do I modify the number of databases my site can have?

  3. Set the database to READ_ONLY mode to ensure there are no updates done to the database while the migration is performed. If you would like to do this, make your backup just prior to setting the database to READ_ONLY mode; otherwise you will not be able to restore the backup to the new database server.

    • To set the database to READ_ONLY, use the following query:

    • When the new database is restored set it to READ_WRITE:

  1. Create a new MSSQL 2008 database in the Cloud Sites Control Panel under the “Features” tab of the domain your MSSQL2005 database is on.

  2. After the database has been created, view its properties and note the change in the hostname. The information for your database will vary from the image depending on what data center your account is hosted in. Use this new MSSQL 2008 hostname to update your connection strings.

  3. Use the web based admin tool, MyLittleAdmin, to back up your MSSQL 2005 database. The link for the online tool can be found in your Cloud Sites Control Panel by clicking on the database under the Features tab. For this backup add “mlb” to the end of the URL. It is important to add this to the URL and not to go through the standard MyLittleAdmin link found in your Cloud Sites Control Panel. Using the links instead of adding the “mlb” may cause session issues between the two MyLittleAdmin versions. For example:

  4. Log in to your original MSSQL 2005 source database.

  5. Back up your MSSQL 2005 database use the MyLittleAdmin tool. When the backup has completed click on the file link to save the backup file to your local machine.

  6. Log in to the MyLittleAdmin link again using your MSSQL 2008 database and log in. Remember the login you use will become the new owner login for the database. Choose restore and upload the backup file you just downloaded in Step 5. Proceed with the restore.

  7. The restore tool may notify you that the previous users have no login mapping on the new SQL 2008 cluster. At this point your new database will be ready. The only access, at this point, is allowed to the owner login that you used to restore the database. If you need to change the owner to another login you created in the Cloud Sites Control Panel or remap users in your database to new logins refer to the article, How to Change ownership and remap database users using the web based admin tool for MSSQL..

Continue the conversation in the Rackspace Community.