Schedule automatic backups for 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.

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

  2. Under Administration, click Schedule database backup.

  3. Next to Automatic database backups are, select On.

  4. Under Automatic database backups occur, select Daily, Weekly, or Monthly to schedule when the backup occurs.

  5. Click Submit.