Wednesday 1 July 2009

Backing Up and Restoring Databases by Using the SQL Server 2000 and SQL Server 2005 Tools (Windows SharePoint Services 2.0)

Creating regular backups allows you to restore your servers and sites in case they happen to fail. To restore a server or server farm from a database backup, you must perform the following steps.

  1. On your server, or on the front-end Web servers in your server farm, in Internet Information Services (IIS), create the virtual servers to host your Web site content. For more information about creating a virtual server, see Extending Virtual Servers (Windows SharePoint Services 2.0).

  2. Using the SQL Server restore tools, restore the databases from the backups.

    For more information about restoring databases in SQL Server, see the SQL Server documentation.

  3. In IIS, create the application pools for the content virtual servers.

    Be sure that you use domain accounts for the application pools, and that these accounts are members of the Security Administrators and Database Creators roles in SQL Server. For more information about creating application pools, see the Help system for Internet Information Services.

  4. On your server or front-end Web servers, install Windows SharePoint Services, and connect to the restored configuration database.


Backing Up and Restoring Databases by Using the SQL Server 2000 and SQL Server 2005 Tools (Windows SharePoint Services 2.0)
Blogged with the Flock Browser