Daily Schedule Backup (Project Server 2013)
Summary: Use the Daily Schedule Backup settings page in SharePoint Central Administration to schedule daily backups of Project Server 2013 objects.
Applies to: Project Server 2013
This article describes how to use the Daily Schedule Backup settings page to select the Project Server 2013 objects that you would like to schedule for back up on a daily basis. This procedure does not back up the physical files of a database (.mdb), but creates backups of specific items in the database. These items are backed up from the Published section to the Archive section in the Project Web App database.
In order to access and use settings on the Daily Schedule Backup page, you must be a farm administrator.
Items you can schedule for backup
You can enable daily backup on the Daily Schedule Backup page for the following Project Server 2013 items:
||Includes project resources, assignments, tasks, custom field values, baseline data
|Enterprise resource pool and calendars
||Includes enterprise resources and enterprise calendars
|Enterprise custom field
||Includes enterprise custom field metadata, enterprise lookup table metadata, enterprise lookup table values
|Enterprise global template
||Includes all Project Professional table, macro, and view definitions
||Includes statusing, Project Center, Portfolio Analyzer, and Resource Center view definitions
|Category and group settings
||Includes settings for all Project Server categories and groups.
Item-level backup and restore of category and group settings apply only in Project Permission Mode. For more information about security modes in Project Server 2013, see Plan user access in Project Server.
To back up data automatically by using a daily schedule
In SharePoint Central Administration, click Application Management.
On the Application Management page, in the Service Application section, click Manage Service Applications.
On the Service Applications page, click the Project Application Service that contains the Project Web App instance for which you want to access the Administrative Backup settings.
On the Manage Project Web Apps page, click the drop-down menu for the PWA instance for which you want to access the Daily Schedule Backup settings, and click Manage.
On the Project Web App Server Settings page, in the Queue and Database Administration section, click Daily Schedule Backup.
On the Daily Backup Schedule page, in the Project Retention Policy box, type the number of versions you want to retain for projects that you back up.
The Project Retention Policy only pertains to projects and not to other enterprise objects. Also note that increasing this setting affects the Archive table in the Project Server 2013 database (ProjectService). The more versions you keep, the more space is required.
For each item in the Item section, select either Schedule or Never from the Option list to indicate whether you want to schedule a backup for that item.
By default, all items you selected on the Daily Backup Schedule page are backed daily, at a time between 12 AM and 3 AM.
As noted in the procedure, the number of versions that are backed up for projects depend on the value you set for the Project Retention Policy. All other items are only backed up to the previous version.
If you do not want to schedule a daily backup, and need to make an immediate backup of these Project Server 2013 items, see Back up item-level objects through Administrative Backup (Project Server 2013).