Backup and Restore Project Server 2007

This post comes to us courtesy of Mark Shea of our Office Assistance area.

Introduction

This post will guide you through the Microsoft Office Project Server 2007 backup and restore process by using the the SharePoint Central Administration Web site.

Set up a file share

If you do not already have a remote file share to store the backup files, you must set one up before backing up your environment.

Set up a remote file share

  1. (Recommended) Make sure SQL 'Setup server account' is using a domain account; see SQL Server books online on how to do it.
  2. Verify that the remote file share can be accessed from both the SQL Server computer and the computer that is hosting Central Administration.
  3. On the remote file server, create a directory and share it out. Be sure to give it access permissions for the account you will be using to backup and restore.
  4. On the Share Permissions tab of file share properties, grant the accounts listed below, Change and Read rights.
  5. On the Security tab of the file share Properties, grant the accounts listed below all the rights except Full Control.

Create required accounts

Accounts needed:

  • SQL server account (if “Local system” is the SQL service account, you must grant permission to the SQL server computer.).
  • Login account (required to do backup and restore using the command prompt).
  • The Windows SharePoint Services 3.0 front-end server account, such as <domain>\<server name>$ (required to do backup and restore using the user interface).
  • The central administrator pool account (required to do backup and restore using the user interface).
  • The Timer service account (requested by UI).

Note The central administrator pool and the Timer service use the same user account.

Note If you receive any errors during the backup or restore process, you must delete the failed “Backup/Restore” timer job before you can run the next backup or restore process. The URL for the Timer service jobs is:

https://<adminsite:port>/_admin/ServiceJobDefinitions.aspx.

Note You do not have to delete the Timer service job if you did the Project Server 2007 backup or restore by using the stsadm.exe command-line tool.

Note The server farm should be taken offline prior to backup.

Back up your environment

To back up your Project Server 2007 installation, do the following:

  1. Navigate to Central Administration; the URL looks like https://<server_name>:port/default.aspx.

  2. Click Operations on the top navigation bar.

  3. In the Backup and Restore section of the Operations page, click Perform a Backup.

  4. On the Select Component to Backup page, choose the components you want to back up, such as Farm or an individual site. You can select any one component and all components under it.

  5. When you have selected all the components you want to back up, click Start Backup Process.

    On the Start Backup page, under Backup File Location, enter the UNC path to the backup folder.

  6. Click OK

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

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

Restoring a Project Server 2007 deployment

This section guides you through the Microsoft Office Project Server 2007 restoration process using Central Administration. It describes how to restore over the original server farm. This document does not describe a migration of Project Server 2007 data.

Restore to the original farm
  1. Navigate to Central Administration; the URL looks like https://<server_name>:port/default.aspx.

     

  2. Operations on the top navigation bar.

  3. In the Backup and Restore section of the Operations page, click Restore from backup.

  4. On the Restore from Backup: Step 1: Select Backup File page, under Backup File Location, enter the UNC path to the backup folder.

  5. On the Restore from Backup: Step 2: Select Backup Package to Restore page, choose the target backup package and click Start Restore Process.

  6. On the Restore from Backup: Step 3: Select Component to Restore page, choose the restore level (Farm, Service, Database or SSP) and click Start Restore Process.

  7. On the Restore from Backup: Step 4: Select Restore Options page, select Overwrite (Create new is the default value) and click OK in the pop-up dialog.

  8. Under New Names, enter the user name and password for the Web applications listed on the page.

  9. Click OK.

Technorati tags: Administration, Project Server 2007