You can restore the following Project Server and SharePoint Products and Technologies databases:

Important:

You can only perform a full farm recovery using the SharePoint Central Administration Web site.

Content database

Draft database

Published database

Archive database

Reporting database

Databases for Shared Services Providers (SSPs)

Central Administration content database

Configuration database

Note:

The configuration database and the Central Administration content database contain computer-specific information. Therefore, you can restore them only to an environment that you configure to be precisely the same, including all software updates, server names, and numbers of servers. That is, you cannot back up the configuration database, change your topology or server roles, and then restore the configuration database.

When protecting Microsoft Office Project 2007, we recommend that you configure a recovery farm—a second farm that is only used to restore data—for site and item recovery. The recovery farm is not intended to be a live farm. The recovery farm does not need to have the same hardware as your primary farm; we recommend that you use a single server installation or a virtual farm.

If your IT environment requires that your database administrator (DBA) must restore the databases associated with the Shared Services Provider (SSP), you must coordinate your backup and recovery operations with your DBA. The account used to restore the databases must be a member of the SQL Server dbcreator fixed server role.