Migrate SQL Server data

  • Article

Updated: January 22, 2009

Applies To: Windows SBS 2008

Note

This is an optional task.

After you finish installing Windows SBS 2008, use the Premium Technologies disc to install the Windows Server® 2008 operating system and SQL Server 2008 Standard for Small Business. You can install SQL Server 2008 Standard for Small Business as your database for a business application.

Note

These instructions explain how to install SQL Server 2008 for Small Business, which comes with Windows SBS 2008 Premium Edition. But you can install SQL Server 2008 Standard Edition instead. To do this, purchase a copy of SQL Server 2008 Standard Edition, and then follow these instructions.

Before you begin, review the following:

  • Do not migrate the instance of SQL Server 2005 Express that is installed on the Source Server for monitoring (SBSMONITORING), because this is not supported.

  • Do not migrate the instance of Windows Internal Database (SQL Server 2005 Embedded Edition) that is installed for Windows Server Update Services and for Windows SharePoint® Services (MICROSOFT##SSEE), because this is not supported.

  • To review the release notes for SQL Server 2008, on the Premium Technologies disc, open either D:\SQL2008\x64\Servers\ReadMeSQL2008.htm or D:\SQL2008\x32\Servers\ReadMeSQL2008.htm (where D is the letter of your DVD drive).

Note

You must be a network administrator to complete this procedure.

To migrate the SQL Server data

  1. Install a new instance of SQL Server 2008 for Windows SBS 2008 for Windows SBS 2008 migration.

  2. Move a SQL Server 2000 instance or SQL Server 2005 instance to SQL Server 2008 for Windows SBS 2008 migration.

  3. Specify SQL Server collation settings for Windows SBS 2008 migration.