Back up and restore databases (Project Server 2010)
Applies to: Project Server 2010
Topic Last Modified: 2009-08-28
If your IT environment requires that your database administrator (DBA) or administrator of your SharePoint Products and Technologies deployment must back up or restore the databases associated with the Shared Services Provider (SSP), you must coordinate your backup and recovery operations with either your DBA or the administrator of the host SharePoint Products and Technologies deployment.
When using SQL Server 2005, the account used to back up the databases must be a member of the Microsoft SQL Server db_backupoperator fixed database role. The account used to restore the databases must be a member of the SQL Server dbcreator fixed server role.
To back up Project Server 2010 databases, see Back up databases (Project Server 2010).
To restore Project Server 2010 databases, see Restore databases (Project Server 2010).