Moving Windows SharePoint Services 2.0 Databases

  • Article

Bryan Jeffries

Microsoft Corporation

Published: November 2003

Abstract

Learn how to move the databases used by Windows SharePoint Services to a different drive on the same server or to a separate server running Microsoft SQL Server 2000. You do not need to be familiar with Microsoft SQL Server tools to use this document.

Getting Started

When you install Microsoft Windows SharePoint Services by using the default settings, the setup program automatically installs Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) and uses it to create the databases for your Web sites. Installing Windows SharePoint Services in this way puts all the files, including the database, in your server computer's \Program Files directory by default.

You may want to move the databases that support Windows SharePoint Services. If the drive containing the Program Files directory does not have enough disk space for your database requirements, move the databases to another drive on your server computer or to a separate server running SQL Server 2000. If you want to take advantage of the more powerful database maintenance tools provided by SQL Server 2000, you must move your databases to a server running SQL Server 2000.

You should back up your databases before moving them. For information about backing up and restoring databases and Web sites, see the topics "Backing Up and Restoring Databases by Using the SQL Server 2000 Tools" and "Backing Up and Restoring Web Sites" in the Microsoft Windows SharePoint Services Administrator'sGuide (https://go.microsoft.com/fwlink/?LinkID=18327\&clcid=0x409).

Note

To move Microsoft Windows SharePoint Services databases, you must be a member of the local Administrators group on the server from which you are moving the database files and on the server to which you are moving the files.

See Also

Concepts

About the Configuration and Content Databases (Windows SharePoint Services 2.0)