How to perform a disaster recovery operation of SharePoint Services Companyweb and SharePoint Services Databases (827701)

SUMMARY

This article describes how to restore the Microsoft Small Business Server 2003 SharePoint Services databases on a new server as part of a disaster recovery operation.

back to the top

Prerequisites

You must follow the steps in this article when you cannot restore the system state on the original server from a backup. For these steps to work, the new server must have the same domain name as the original server where the backup of the database and the backup of the log files were performed. The required database and logs files are as follows:

• STS_Config.mdf
• STS_Config_log.ldf
• STS_Servername_1.mdf
• STS_Servername_1_log.ldf

Before you can start to restore the SharePoint Services databases, all the following criteria must be met:

• Microsoft Small Business Server 2003 with the intranet component is installed.
• The SharePoint Services Companyweb Web site must be working with a new, unmodified database.
• The SharePoint Services Companyweb Web site must be accessible (http://companyweb).

back to the top

Restore the Small Business Server 2003 SharePoint Services databases

The steps in this section describe how to restore the Small Business Server 2003 SharePoint Services databases. This section includes steps to restore any additions that are made to the default SharePoint Services installation. This includes any top-level SharePoint sites that must be created and additional data files. Specifically, you must follow the steps in this section that start with ** to restore any additions that are made to the default SharePoint services installation. If you want to restore only the default SharePoint databases without any modifications, you can safely ignore the steps that start with **.

1. Verify that SharePoint Services Companyweb Web site (http://companyweb) is accessible.
2. **Create any additional top-level Web sites that existed on the old server with Microsoft Internet Information Services (IIS). These Web sites are located outside the top-level SharePoint site of the Companyweb virtual server.
3. **Create DNS host records for any additional, top-level SharePoint sites that existed on the old server.
4. Stop the MSSQL$SharePoint service. To do this, follow these steps:
   1. Click Start, click Run, type cmd, and then click OK.
   2. At the command prompt, type net stop mssql$sharepoint, and then press ENTER.
   3. To close the Command Prompt window, type exit, and then press ENTER.
5. Make a backup of the \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder.
6. Restore only the configuration and the content databases to \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data. Specifically, restore the following configuration files and databases:
   • STS_Config.mdf
   • STS_Config_log.ldf
   • STS_Servername_1.mdf
   • STS_Servername_1_log.ldf
   Note Do not restore any other default files such as the Master.mdf file or the Model.mdf file.
7. **If you created any additional content databases, restore them to the \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder.
8. Start the MSSQL$SharePoint service. To do this, follow these steps:
   1. Click Start, click Run, type cmd, and then click OK.
   2. At the command prompt, type net start msql$sharepoint, and then press ENTER.
   3. To close the Command Prompt window, type exit, and then press ENTER.
9. If you try to access the Companyweb Web site, its subwebs, or any other top-level SharePoint Web sites, you may receive one or more of the following error messages:
   
   Message 1
   The virtual server that is referenced here is not in the config database.
   Message 2
   The page cannot be found
   Message 3
   The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
   Message 4
   HTTP 400 - Bad Request Internet Explorer

back to the top

Remove Small Business Server 2003 SharePoint Services from Companyweb

Before you can access the restored Companyweb Web site, you must first remove SharePoint Services from the Companyweb virtual server, and then re-extend the Companyweb virtual server by using SharePoint Services. To remove SharePoint Services from Companyweb, follow these steps:

1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration.
2. Under Virtual Server Configuration, click Configure virtual server settings.
3. On the Virtual Server List page, click companyweb.
4. Under Virtual Server Management, click Remove Windows SharePoint Services from virtual server.
5. On the Remove Windows SharePoint Services from Virtual Server page, click Remove without deleting content databases, and then click OK. You receive the following error message:
   The virtual server that is referenced here is not in the config database.

back to the top

Extend the Companyweb virtual server to Small Business Server 2003 SharePoint Services

To re-extend the Companyweb virtual server by using SharePoint Services, follow these steps:

1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration.
2. Under Virtual Server Configuration, click Extend or upgrade virtual server.
3. On the Virtual Server List page, click companyweb.
4. In the Provisioning Options section, click Extend and map to another virtual server.
5. In the Server Mapping section, click companyweb.
6. In the Application Pool section, click Use an existing application pool, click DefaultAppPool (NT AUTHORITY\NETWORK SERVICE), and then click OK.

back to the top

Configure the Small Business Server 2003 SharePoint Services accounts

If you try to access the Companyweb Web site, its sub webs, or any other top-level SharePoint Web sites by using the built-in Administrator account, you receive the following error message: This error occurs because the Administrator account is the Site Collection Owner and has a security identifier (SID) that does not match the SID in the database. To resolve this problem, you must log on with another domain administrator account to reset ownership of the site collection. To do this, follow these steps:

1. Create a new domain administrator account by using the Add User Wizard that is included with SBS 2003. Do not use the Active Directory Users and Computers snap-in to create the user account. To create a domain administrator account by using the Add User Wizard, follow these steps:
   1. Click Start, and then click Server Management.
   2. In Server Management, click Users.
   3. Under Manage Users, click Add a User.
   4. On the first page of the Add User Wizard, click Next.
   5. Type a name for the account, and then click Next.
   6. Type and then confirm a password for the new account, and then click Next.
   7. In the Templates box, click Administrator Template, and then click Next.
   8. Click Do not set up a computer, and then click Next.
   9. Click Finish to complete the wizard.
2. Log on to the server by using the domain administrator account that you created in step 1.
3. Set the new domain administrator account as the new Site Collection Owner for the Companyweb Web site. To do this, follow these steps:
   1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration.
   2. Under Security Configuration, click Manage site collection owners.
   3. In the Web Site URL box, type http://companyweb, and then click View.
   4. In the User name box that is next to Site Collection Owner, change the username to be the new domain administrator account, and then click Check name.
   5. Click OK.
4. Remove the site collection users for the Companyweb Web site. To do this, follow these steps:
   1. Click Start, click Run, type http://companyweb, and then click OK.
   2. On the Companyweb home page, click Site Settings.
   3. Under Administration, click Go to Site Administration.
   4. Under Site Collection Administration, click View site collection user information.
   5. On the Manage Site Collection Users page, write down all the user accounts. You will use this information to re-create the user accounts.
   6. Select all accounts except the domain administrator account that you created in step 1, click Remove Selected Users, and then click OK to confirm. Make sure to remove the following template accounts:
      • Administrator Tmpl
      • Mobile User Tmpl
      • Power User Tmpl
      • User Tmpl

back to the top

Re-create the Small Business Server 2003 SharePoint Services user accounts

To re-create the Small Business Server 2003 SharePoint Services user accounts, follow these steps:

1. Click Start, click Run, type http://companyweb, and then click OK.
2. On the Companyweb home page, click Site Settings.
3. Under Administration, click Manage Users.
4. On the Manage Users page, click Add Users.
5. Under Step 1: Choose Users, type the following accounts in the Users box:

   administrator@domain.local; Administrator Tmpl@domain.local; Power User Tmpl@domain.local

   In the account names, domain.local is the internal Active Directory domain name.
6. Under Step 2: Choose Site Groups, click to select the Administrator check box, and then click Next.
7. Under Step 3: Confirm Users, verify that the User Name and the Display Name are correct.
8. Under Step 4: Send E-mail, click to clear the Send the following e-mail to let these users know they've been added check box, and then click Finish.
9. On the Manage Users page, click Add Users.
10. Type the following in the Users box:

    Mobile User Tmpl@domain.local; User Tmpl@domain.local

11. Click to select the Web Designer check box, and then click Next.
12. Verify that the User Name and the Display Name are correct.
13. Click to clear the Send the following E-mail to let the users know they have been added check box, and then click Finish.
14. Repeat steps 9 through 14 to re-create the rest of the accounts and to assign them to the correct Site Groups.
    
    Note By default, Users and Mobile Users belong to the Web Designer site group. Power Users and Administrators belong to the Administrator site group.
15. **For additional, top-level Web sites, repeat steps 1 through 5 in the "Remove Small Business Server 2003 SharePoint Services from Companyweb" section, and then repeat steps 1 through 6 in the "Extend the Companyweb virtual server to Small Business Server 2003 SharePoint Services" section.
16. We also recommend that you reconfigure the built-in Administrator account to be the Site Collection Owner for the Companyweb Web site. After you do this, you can remove or disable the new domain administrator account that you created in this article. To reconfigure the built-in Administrator account to be the Site Collection Owner, follow steps 3a through 3e in the "Configure the Small Business Server 2003 SharePoint Services accounts" section. When you follow these steps, enter Administrator as the new Site Collection Owner instead of the new domain administrator account.

back to the top