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 translations Article translations
Article ID: 829113 - View products that this article applies to.
Expand all | Collapse all

On This Page

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_ServerName_1.mdf
    • STS_ServerName_1_log.ldf

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

MORE INFORMATION

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.
  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 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.
  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 2.0 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 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
  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 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.
  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 2.0 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 2.0:
    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\NETWORK SERVICE).
    7. Click OK.
  13. 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.

REFERENCES

For more information about the Windows SharePoint Services 2.0 Software Development Kit (SDK), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=aa3e7fe5-daee-4d10-980f-789b827967b0&DisplayLang=en
For more information about the Windows SharePoint Services Administrator's Guide, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=a637eff6-8224-4b19-a6a4-3e33fa13d230&displaylang=en
Note If you are reinstalling the Windows SharePoint Services 2.0 CompanyWeb intranet site, you must use the updated CD3 disc that includes the software update that Microsoft Knowledge Base (KB) article 832880 describes. Do not use the CD3 disc that was distributed with Windows Small Business Server 2003 before February 2004. If you use the CD3 disc that was distributed before February 2004, the intranet component will not successfully install.

If the intranet component does not successfully install, permit Windows Small Business Server 2003 Setup to finish, and then reapply the KB 832880 software update to the server. The KB 832880 software update will complete the CompanyWeb intranet site installation correctly.

For more information about the software update that resolves the installation issue in Windows Small Business Server 2003, click the following article number to view the article in the Microsoft Knowledge Base:
832880 You cannot successfully install the intranet component or connect to http://companyweb in Windows Small Business Server 2003
For more information about how to recover the CompanyWeb intranet database and the Windows SharePoint Services database if a change has been made to the Active Directory domain databases since the last time that the Windows SharePoint Services data files were backed up, click the following article number to view the article in the Microsoft Knowledge Base:
827701 How to perform a disaster recovery operation of SharePoint Services Companyweb and SharePoint Services Databases
For more information about how to install the Windows Small Business Server 2003 intranet component and the CompanyWeb intranet site, click the following article number to view the article in the Microsoft Knowledge Base:
829114 How to remove and how to install the Windows Small Business Server 2003 SharePoint Services companyweb Web site

Properties

Article ID: 829113 - Last Review: December 12, 2007 - Revision: 9.0
APPLIES TO
  • Microsoft Windows Small Business Server 2003 Premium Edition
  • Microsoft Windows Small Business Server 2003 Standard Edition
  • Microsoft Windows SharePoint Services 2.0
Keywords: 
kbhowto KB829113

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com