Migrate the internal website for Windows SBS 2011 Standard migration
Published: January 28, 2011
Updated: February 24, 2011
Note
If you do not have an internal website for your organization, skip this section and continue with Move fax data for Windows SBS 2011 Standard migration.
For migrations to Windows SBS 2011 Standard networks containing more than one server, the following terms are used to distinguish new Destination Servers.
Primary Server: The first server on a Windows SBS 2011 Standard network that contains more than one server.
Second Server: The second server on a Windows SBS 2011 Standard network. The Second Server runs the Windows SBS 2011 Premium Add-on.
Note
The following procedures are for migrating your internal website from Windows SharePoint Services 3.0 running on Windows SBS 2011 Standard to a Destination Server that is running Windows SBS 2011 Standard or to a Second Server running Windows SBS 2011 Premium Add-on. If you are migrating from SharePoint Foundation 2010 on Windows SBS 2011 Standard, follow the steps in Move all SharePoint Foundation 2010 databases for Windows SBS 2011 Standard to another server.
To migrate the internal website
In the Migration Wizard, on the Migration Wizard Home page, click Migrate SharePoint website, and then click Next.
If you do not want to migrate your internal website, click Skip Task, and then click Next.
If you want to migrate your internal website, perform the steps in the following procedures.
Back up the content database. See To back up the content database for the internal website (CompanyWeb).
Restore the content database to the Destination Server or to a Second Server. See To restore content database to the Destination Server or To restore content database to Second Server running Windows SBS 2011 Premium Add-on.
Mount the database. See To mount the content database.
Grant read permissions. See To grant read permissions on the Destination Server.
Enable SharePoint Foundation 2010 features. See To enable SharePoint Foundation 2010 features.
Configure Search. To configure Search for “CompanyWeb”.
To back up the content database for the internal website (CompanyWeb)
Click Start, click All Programs, click Microsoft SQL Server 2008 R2, click SQL Server Management Studio Express, and then click run as Administrator.
For the Server Name, type (local)\SharePoint.
In SQL Server Management Studio Express (SSMSE), in the navigation pane, expand Databases.
Right-click the content database (ShareWebDb) for the internal website, click Tasks, and then click Back Up.
In the Back Up Database dialog box, do the following:
Leave the defaults in the Source and Backup set sections.
In the Destination section, set Backup to Disk, then add the <full path location>.bak for the backup set (for example, c:\backup\Companyweb.bak).
Note
Choose a location on which you have read/write permissions. You may not have permissions on the root path, such as “c:\”
3. Click **OK** to create the backup set.
4. Click **OK** in the **Backup completed successfully** dialog box.
5. Copy the backup file to a removable storage device.
To restore content database to the Destination Server
Copy your backup files of the content database from the Source Server to the Destination Server.
Go to SharePoint 2010 Central Administraton, and click Manage Content Databases. Remove SharedwebDb, which is associated with SBS SharePoint.
Click Start, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Central Administration.
Click Manage content database under Application management.
Click ShareWebDb.
Check Remove content database and click Yes. Click OK to close the page.
Use Management Studio to delete the original ShareWebDb database on the Destination Server and restore the ShareWebDb database from the Source Server, as follows
Click Start, Click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio Express. Run it as Administrator.
Enter <server name>\SharePoint as server name and click connect.
Expand databases, right click ShareWebDb and choose delete. Check close existing connections only and click OK.
Right-click Databases, and then click Restore Database. The Restore Database dialog box appears.
In the Restore Database dialog box, on the General page, type ShareWebDb.
In the To a point in time text box, retain the default (Most recent possible).
To specify the source and location of the backup sets to restore, click From device, and then click … to select the backup file.
In the Specify Backup dialog box, in the Backup media box, be sure that File is selected.
In the Backup location area, click Add.
In the Locate Backup File dialog box, select the file that you want to restore, click OK, and then, in the Specify Backup dialog box, click OK.
In the Restore Database dialog box, under Select the backup sets to restore grid, select the Restore check box next to the most recent full backup.
In the Restore Database dialog box, under Select a page click on the Options page. Under Restore options, select the Overwrite the existing database check box.
If you have moved the data storage location for SharePoint, restore the database to the new location.
Click OK to start the restore process.
If you are not migrating the website to a Second Server, skip the following procedure and continue with To mount the content database.
To restore content database to Second Server running Windows SBS 2011 Premium Add-on
Logon to the Second Server running Windows SBS 2011 Premium Add-on. Click Start, click All Programs, click Microsoft SQL Server 2008 R2, then click SQL Server Management Studio. Run it as Administrator.
Enter <server name>\<instance name> as server name and click Connect. An instance is created during SQL Server setup.
Right-click Databases, and then click Restore Database. The Restore Database dialog box appears.
In the Restore Database dialog box, on the General page, type ShareWebDb.
In the To a point in time text box, retain the default (Most recent possible).
To specify the source and location of the backup sets to restore, click From device, and then click Browse to select the backup file.
In the Specify Backup dialog box, in the Backup media box, be sure that File is selected.
In the Backup location area, click Add.
In the Locate Backup File dialog box, select the file that you want to restore, click OK, and then, in the Specify Backup dialog box, click OK.
In the Restore Database dialog box, under Select the backup sets to restore grid, select the Restore check box next to the most recent full backup.
In the Restore Database dialog box, on the Options page, under Restore options, select the Overwrite the existing database check box.
Click OK to start the restore process.
To mount the content database
Click Start, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Management Shell. Run it as Administrator. Use the following command to mount your restored content database to company web.
Mount-SPContentDatabase –Name “ShareWebDb" –WebApplication <web app url>
An example URL is “https://sites:987”
If you want new SharePoint Foundation 2010 functionality and features, you must reset any customized pages to use the template by performing the steps in the following procedure. Resetting the page basically discards the customizations and attaches your page to the appropriate master page. Any customizations you want can then be transferred to the master page instead of being stored in individual pages.
To enable SharePoint Foundation 2010 features
Go to https://companyweb. Click Site Action, choose Site Settings, and choose Reset to site definition under Site Actions.
Go back to https://companyweb. Click Site Action, choose Visual Upgrade and click Update All sites.
To configure Search for “CompanyWeb”
Click Start, click All Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Central Administration.
Choose Manage Services on Server under System Setting.
Click Stop on the right of SharePoint Foundation Search and confirm.
Then click Start on the right of SharePoint Foundation Search.
Choose to search every 5 minutes in the configuration page. Click OK.
Go to Administration home page and click Manage content database under application management.
Click ShareWebDb.
Choose your server as search server and click OK.
Note
You can use the free SharePoint Designer 2010 product to do advanced customization of your SharePoint Foundation 2010 website.
SharePoint Designer 2010 (32-bit)
SharePoint Designer 2010 (64-bit)
To grant read permissions on the Destination Server
On the Destination Server, run Internet Explorer, and type https://companyweb in the address bar, and then press Enter.
Click Site Action and choose Site Permissions.
Click Grant Permissions. Enter the information below into the dialog box:
In Users/Groups, type NT Authority\System and click Check Name icon.
In Grant Permissions, select Read.
Unselect the check box for send welcome e-mail to new users.
Click OK.