Steps performed on the Source Server for Windows SBS 2008 migration

Updated: January 22, 2009

Applies To: Windows SBS 2008

To configure the internal Web site (CompanyWeb) to allow access from Windows Small Business Server 2008

1. In the Migration Wizard, on the Migration Wizard Home page, click Migrate SharePoint Web site, and then click Next.

2. Log on to the Source Server with an administrator account, and then open the Internet Explorer® Internet browser.

3. In Address, type https://InternalHeaderName (for example, https://companyweb), and then click GO. Make sure you include the "s" after "http," and verify that you are accessing the encrypted Windows SharePoint Services Web site.

4. On the Home page, click Site Settings.

5. On the Site Settings page, in the Administration section, click Manage users, and then click Add Users.

6. On the Add Users page, do the following:

   1. In the text box in Step 1: Choose Users, type Windows SBS SharePoint_OwnersGroup.

   2. In Step 2: Choose Site Groups, select the Administrator check box, and then click Next.

   3. Click Finish to accept the default entries. Note that the new group is added to the users list on the Manage Users page.

7. On the Manage Users page, click Add User.

8. On the Add Users page, do the following:

   1. In the text box in Step 1: Choose Users, type Windows SBS SharePoint_MembersGroup.

   2. In Step 2: Choose Site Groups, select the Contributor check box, and then click Next.

   3. Click Finish to accept the default entries. Note that the new group is added to the users list on the Manage Users page.

9. On the Manage Users page, click Add User.

10. On the Add Users page, do the following:

    1. In the text box in Step 1: Choose Users. type Windows SBS SharePoint_VisitorsGroup.

    2. In Step 2: Choose Site Groups, select the Reader check box, and then click Next.

    3. Click Finish to accept the default entries. Note that the new group is added to the users list on the Manage Users page.

11. Close the internal Web site.

12. Notify users that the internal Web site is going to be migrated to Windows SBS 2008 and that the Source Server will be offline during this process.

To run the Prescan tool on the Source Server

1. On the Destination Server, copy the Windows SharePoint Services 3.0 prescan.exe utility from the folder %Program Files%\Common Files\Microsoft Shared\Web Server Extensions\12\Bin to removable media.

2. Save the folder on the Source Server.

3. On the Source Server, click Start, click Run, type cmd in the text box, and then click ENTER.

4. In the Command Prompt window, switch to the folder where you saved prescan.exe, type prescan.exe /V https://companyweb at the command prompt, and then press ENTER.

5. Note any messages about errors, and review the log files that are created by prescan.exe. If there are errors, make the necessary corrections, and then run prescan.exe again.

To stop the internal Web site (CompanyWeb) on the Source Server

1. On the Source Server, click Start, and then click Server Management.

2. In the navigation pane, click Advanced Management, click Internet Information Services, click <ServerName> (local), and then click Web Sites.

3. Right-click the internal Web site, and then click Stop.

To connect to Windows SharePoint Services

1. On the Source Server, click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio Express.

2. In the Server name dropdown list, click <ServerName>\SHAREPOINT, and then click Connect.

To back up the content database for the internal Web site (CompanyWeb)

1. In SQL Server Management Studio Express with SP2 (MSSMSE), in the navigation pane, expand Databases.

2. Right-click the content database for the internal Web site, click Tasks, and then click Backup.

3. In the Back Up Database dialog box, do the following:

   1. Leave the defaults in the Source and Backup set sections.

   2. In the Destination section, make sure Backup to is set to Disk, and then add the <full path location>.bak for the backup set (for example, c:\backup\CompanyWeb.bak).

   3. Click OK to create the backup set.

   4. Click OK in the Backup completed successfully dialog box.

If you receive an error stating "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Express.Smo)," you must add the following value to the Registry via the Regedit tool:

• Registry key: HKLM\Software\Microsoft\Microsoft SQL Server\SharePoint\MSSQLServer

• Name: BackupDirectory

• Type: Reg_SZ

• Value: C:

To detach the database

1. In Microsoft SQL Server Management Studio Express SP2 (MSSMSE), in the navigation pane, expand Databases.

2. Right-click the content database for the internal Web site, click Tasks, and then click Detach.

3. In the Detach Database dialog box, do the following:

   1. Select the check box in the Drop Connections column.

   2. Clear the check box in the Update Statistics column.

   3. Click OK.

4. In the navigation pane, in the Databases folder, verify that the STS_<Windows SBS 2003ServerName>_1 database is no longer displayed.

5. Close MSSMSE.

6. Copy the database files to the Destination Server.

   1. By default, the files are in the folder C:\ Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder on the Source Server.

   2. By default, the files are named as follows:

      STS_<ServerName>_1.mdf

      STS__<ServerName>_1_Log.ldf