Export (0) Print
Expand All

Back up and restore databases (Project Server 2010)

Published: May 12, 2010

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 Important:

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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft