Back up databases (Project Server 2010)


Applies to: Project Server 2010

Topic Last Modified: 2009-10-27

This article guides you through the process of backing up a Microsoft SQL Server database.

Backing up databases by using Project Server 2010 built-in tools


This method should only be used to create a full farm back up. The SharePoint Central Administration Web site is the only recommended way to perform a full farm back up or recovery.

Use this procedure to back up a database by using the SharePoint Central Administration Web site.

To back up your farm using Office Project Server built-in tools, you must use the following accounts and permissions:

  • You must be logged on to the server that runs Central Administration.

  • You must have a shared folder that you will use to store the backup files.


You must be a member of the Farm Administrators SharePoint group to complete the following procedure.


If any failures occur during the backup process, the entire process must be restarted to prevent data corruption.

Back up a database by using Central Administration

  1. In the SharePoint Central Administration Web site, on the Operations page, in the Backup and Restore section, click Perform a backup.

  2. On the Select Component to Backup page, select the check boxes for the databases you want to back up. Click Continue to Backup Options.

  3. On the Select Backup Options page, a differential backup backs up data created or changed since the last backup. If you are performing a combination of full and differential backups, restoring requires you to have the last full backup, the last differential backup, and intervening differential backups.

    • In the Backup Content section, verify that the database you selected is displayed.

    • In the Type of Backup section, select Full.

    • In the Backup File Location section, type the UNC path of the backup folder.

  4. Click OK.

    You can view the backup job status on the backup status page by clicking Refresh. The page also refreshes every 30 seconds automatically. Backup and recovery is a Timer service job, so it may take few seconds for the backup to start.

    If you receive any errors, you can find more information by looking in the spbackup.log at the UNC path you specified above.