Microsoft KB Archive/829113

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

Article ID: 829113

Article Last Modified on 12/12/2007

-

APPLIES TO


 * Microsoft Windows Small Business Server 2003 Premium Edition
 * Microsoft Windows Small Business Server 2003 Standard Edition
 * Microsoft Windows SharePoint Services 2.0

-





SUMMARY
This article describes how to restore a Microsoft Windows SharePoint Services 2.0 database from a backup copy to a server where the Microsoft Windows Small Business Server 2003 CompanyWeb intranet site and Microsoft SQL Server or Microsoft SQL Server Desktop Engine (also known as MSDE 2000) have been reinstalled.

For these steps to work, all the following prerequisites must be met:
 * The Microsoft Active Directory directory service domain database has not changed since the last time that a backup copy of the Windows SharePoint Services 2.0 data files was created.
 * The System State of the original server has been successfully restored from the backup copy.
 * The Windows Small Business Server 2003 intranet component has been installed.
 * The CompanyWeb intranet site (http://companyweb) is accessible.
 * The following database files and log files are available for a successful restore:
 * STS_Config.mdf
 * STS_Config_log.ldf
 * STS_ _1.mdf
 * STS_ _1_log.ldf

Note In these file names,  is a placeholder for the name of your server computer.



Restore the Windows SharePoint Services 2.0 CompanyWeb database
To restore the Windows SharePoint Services 2.0 CompanyWeb database, follow these steps.

Note These steps include the steps to restore any additions that were made to the default Windows SharePoint Services 2.0 Web site. These additions may have been made to the top-level Windows SharePoint Services 2.0 sites and to additional data files. If the Windows SharePoint Services 2.0 data that you are recovering does not include any additions, ignore step 3, step 8, and step 13.  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. After the Intranet component has been successfully installed, verify that the CompanyWeb intranet site (http://companyweb) is accessible. If you must restore any additions that were made to the default Windows SharePoint Services 2.0 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 2.0 site of the CompanyWeb virtual server that existed on the previous server. Stop the MSSQL$SharePoint and the SharePoint Timer services:  Click Start, and then click Run. In the Open box, type cmd, and then click OK. At the command prompt, type net stop mssql$sharepoint, and then press ENTER.</li> Type net stop sptimer, and then press ENTER.</li> To close the command prompt, type exit, and then press ENTER.</li></ol> </li> Stop the companyweb Web site: <ol style="list-style-type: lower-alpha;"> Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.</li> In IIS Manager, expand  , and then expand Web Sites.</li> Under Web Sites, right-click companyweb, and then click Stop.</li></ol> </li> 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 2.0 databases.</li> Restore only the following configuration database files and content database files to the Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder: <ul> STS_Config.mdf</li> STS_Config_log.ldf</li> STS_ _1.mdf</li> STS_ _1_log.ldf</li></ul>

Note Do not restore any other default files such as the Master.mdf file or the Model.mdf file.</li> If you must restore any additions that were made to the default Windows SharePoint Services 2.0 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

</li> Start the MSSQL$SharePoint and the SharePoint Timer services: <ol style="list-style-type: lower-alpha;"> Click Start, and then click Run.</li> <li>In the Open box, type cmd, and then click OK.</li> <li>At the command prompt, type net start mssql$sharepoint, and then press ENTER.</li> <li>Type net start sptimer, and then press ENTER.</li> <li>To close the Command Prompt window, type exit, and then press ENTER.</li></ol>

Note If you try to access the CompanyWeb intranet site (http://companyweb), any subsites, or any other top-level Windows SharePoint Services 2.0 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.</li> <li>Start the companyweb Web site: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.</li> <li>In IIS Manager, expand  , and then expand Web Sites.</li> <li>Under Web Sites, right-click companyweb, and then click Start.</li></ol> </li> <li>Remove Windows SharePoint Services 2.0 from CompanyWeb intranet site: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Administrative Tools, and then click SharePoint Central Administration (http://localhost:8081).</li> <li>Under Virtual Server Configuration, click Configure virtual server settings.</li> <li>On the Virtual Server List page, click the virtual server that you want to configure. In this example, click the companyweb virtual server.</li> <li>Under Virtual Server Management on the Virtual Server Settings page, click Remove Windows SharePoint Services from Virtual Server.</li> <li>On the Remove Windows SharePoint Services from Virtual Server page, click Remove without deleting content databases.</li> <li>Click OK. You will receive the following error message:

The virtual server that is referenced here is not in the configuration database

</li></ol> </li> <li>Extend the CompanyWeb intranet site by using Windows SharePoint Services 2.0: <ol style="list-style-type: lower-alpha;"> <li>Click Start, point to Administrative Tools, and then click SharePoint Central Administration (http://localhost:8081).</li> <li>On the Central Administration page under Virtual Server Configuration, click Extend or upgrade virtual server.</li> <li>On the Virtual Server List page, click the name of the virtual server to extend. In this case, click companyweb.</li> <li>On the Extend Virtual Server page under Provisioning Options, select Extend and map to another virtual server.</li> <li>Under Server Mapping, click companyweb.</li> <li>Under Application Pool, click Use an existing application pool, and then click DefaultAppPool (NT AUTHORITY\NETWORK SERVICE).</li> <li>Click OK.</li></ol> </li> <li>If you must restore any additions that were made to the default Windows SharePoint Services 2.0 services, repeat steps 11 and 12for the additional top-level SharePoint sites.</li></ol>

<div class="references_section">