Move SQL Server data for Windows SBS 2008 migration
Updated: March 3, 2009
Applies To: Windows SBS 2008
This is an optional task.
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.
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).
You must be a network administrator to complete this procedure.