Move SQL Server data for Windows SBS 2008 migration

Applies To: Windows SBS 2008

Note

This is an optional task.

These instructions are for migrating from Windows SBS 2003. If you are migrating from Windows SBS 2008, see the Microsoft Web site (http://go.microsoft.com/fwlink/?LinkId=144396).

After you finish installing Windows SBS 2008, use the Premium Technologies disc to install Windows Server 2008 and Microsoft 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 the version of SQL Server that comes with Windows SBS 2008 Premium Edition on an additional server that is running Windows Server 2008. 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 to install it on an additional server that is running Windows Server 2008.

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 SQL Server 2008 release notes, 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 SQL Server data

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

  2. Move a SharePoint instance of SQL Server 2000 Standard for Windows SBS 2008 migration

  3. Move a SharePoint instance of SQL Server 2005 Workgroup for Windows SBS 2008 migration

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

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