Export (0) Print
Expand All

Migrate SQL Server data

Updated: January 22, 2009

Applies To: Windows SBS 2008

noteNote
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.

noteNote
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).

noteNote
You must be a network administrator to complete this procedure.

To migrate the SQL Server data

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft