Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Back up and restore the database

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

About the collaboration database

SharePoint Team Services relies on a Microsoft SQL Server (either SQL Server 7.0 or MSDE) database to store information such as:

Each virtual server has its own database. The Webs and subwebs on that virtual server share the database, although their information is stored in separate tables within the database.

As a server administrator, you can specify database settings. For example, you can schedule automatic back-up processes or specify the default database to use for all Webs on a virtual server.

Administrators with rights to the virtual server can back up or restore the database for the entire virtual server.

To back up the database

  1. On the Server Administration page, under Virtual Servers, click the Administrationlink next to the virtual server you want to backup.

  2. Under Administration, click Backup and restore database.

  3. In the Database Backup area, type the path and filename to use for the backup file.

    The backup process creates a backup file with the filename and path you specify. Be sure that the path you type is a valid path on your server computer.

  4. Click Backup.

To restore the database

  1. On the Server Administration page, under Virtual Servers, click the Administrationlink next to the virtual server you want to backup.

  2. Under Administration, click Backup and restore database.

  3. In the Database Restore area, type the path and filename of the backup file you want to restore.

  4. Click Restore.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.