Back up and restore databases (Project Server 2007)
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2008-11-19
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.
Task requirements
Important
When using SQL Server 2005, the account used to back up the databases must be a member of the 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 Office Project Server 2007 databases, see Back up databases (Project Server 2007).
To restore Office Project Server 2007 databases, see Restore databases (Project Server 2007).