How to restore a Windows SharePoint Services CompanyWeb database after the intranet component and SQL Server or MSDE 2000 have been removed on Windows Small Business Server (829113)

MORE INFORMATION

Restore the Windows SharePoint Services CompanyWeb database

1. To reinstall the intranet component, run Windows Small Business Server Setup.
   
   Note When you reinstall the Windows Small Business Server intranet component, the reinstall process does not reinstall the server certificate on the CompanyWeb virtual server. If you plan to access a CompanyWeb virtual server by using Secure Sockets Layer (SSL), you must run the Configure E-mail and Internet Connection Wizard. This wizard installs a new server certificate on the CompanyWeb virtual server and sets SSL to use port 444.
2. After the Intranet component has been successfully installed, verify that the CompanyWeb intranet site (http://companyweb) is accessible.
3. If you must restore any additions that were made to the default Windows SharePoint Services services, you must use Microsoft Internet Information Server (IIS) to re-create any additional top-level Web sites that were not included in the top-level Windows SharePoint Services site of the CompanyWeb virtual server that existed on the previous server.
4. Stop the MSSQL$SharePoint and the SharePoint Timer services:
   1. Click Start, and then click Run.
   2. In the Open box, type cmd, and then click OK.
   3. At the command prompt, type net stop mssql$sharepoint, and then press ENTER.
   4. Type net stop sptimer, and then press ENTER.
   5. To close the command prompt, type exit, and then press ENTER.
5. Stop the companyweb Web site:
   1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
   2. In IIS Manager, expand server_name (local computer), and then expand Web Sites.
   3. Under Web Sites, right-click companyweb, and then click Stop.
6. Make a backup copy of the Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder. This is the default installation folder for the Windows SharePoint Services databases.
7. Restore only the following configuration database files and content database files to the Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder:
   • 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.
8. If you must restore any additions that were made to the default Windows SharePoint Services services, you must restore the additional content databases that you created to the original data folder where you created them.
   
   For more information about how to back up and how to restore a Windows SharePoint Services CompanyWeb database, click the following article number to view the article in the Microsoft Knowledge Base:

   829112 How to back up and restore http://companyweb data in Windows Small Business Server 2003

9. Start the MSSQL$SharePoint and the SharePoint Timer services:
   1. Click Start, and then click Run.
   2. In the Open box, type cmd, and then click OK.
   3. At the command prompt, type net start mssql$sharepoint, and then press ENTER.
   4. Type net start sptimer, and then press ENTER.
   5. To close the Command Prompt window, type exit, and then press ENTER.
   Note If you try to access the CompanyWeb intranet site (http://companyweb), any subsites, or any other top-level Windows SharePoint Services site now, you will receive the following error message:
   The Web site that is referenced here is not in the configuration database
   To resolve this issue, go to step 10.
10. Start the companyweb Web site:
    1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
    2. In IIS Manager, expand server_name (local computer), and then expand Web Sites.
    3. Under Web Sites, right-click companyweb, and then click Start.
11. Remove Windows SharePoint Services from CompanyWeb intranet site:
    1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration (http://localhost:8081).
    2. Under Virtual Server Configuration, click Configure virtual server settings.
    3. On the Virtual Server List page, click the virtual server that you want to configure. In this example, click the companyweb virtual server.
    4. Under Virtual Server Management on the Virtual Server Settings page, 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.
    6. Click OK. You will receive the following error message:
       The virtual server that is referenced here is not in the configuration database
12. Extend the CompanyWeb intranet site by using Windows SharePoint Services:
    1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration (http://localhost:8081).
    2. On the Central Administration page under Virtual Server Configuration, click Extend or upgrade virtual server.
    3. On the Virtual Server List page, click the name of the virtual server to extend. In this case, click companyweb.
    4. On the Extend Virtual Server page under Provisioning Options, select Extend and map to another virtual server.
    5. Under Server Mapping, click companyweb.
    6. Under Application Pool, click Use an existing application pool, and then click DefaultAppPool (NT AUTHORITY\NETWORD SERVICE).
    7. Click OK.
13. If you must restore any additions that were made to the default Windows SharePoint Services services, repeat steps 11 and 12for the additional top-level SharePoint sites.