Microsoft Project 2010
The official blog of the Microsoft Project product team. Learn how to manage your work effectively

Backup and Restore Project Server 2007

Backup and Restore Project Server 2007

Rate This
  • Comments 43

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:

http://<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 http://<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 http://<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.

  • Hi there,

    Thanks for this information - I had a quick go at this, but what I am not to sure about (and it was also not specified in the post), is exactly on which level you select components to backup and restore if you only want to backup or restore a Project Server installation.

    Do we need to select the whole sharepoint environmnent?

    Thanks

  • Having had a go at restoring a 2007 system already I can tell you that all you need is the sharepoint content database as well as the project databases.  From this you can recover everything.

  • Un buon articolo passo per passo (con tanto di screenshots) su come impostare il Backup e Restore su

  • Have set up a very low security share (everyone - change + read) NTFS set similarly on a File Server, initiated the backup but nothing started.

    Windows SharePoint Services Timer - Started (Domain Acc OK)

    Windows SharePoint Services VSS Writer - Manual (Local System)

    SQL Server VSS Writer - Manual (Local System)

    Attempted with stsadm.exe to same share.

    The backup stalls at:

    [2/2/2007 1:28:24 PM]: Verbose: Starting object: Windows SharePoint Services Help Search.

    [2/2/2007 1:28:25 PM]: Progress: [Windows SharePoint Services Help Search] 50 percent complete.

    [2/2/2007 1:28:25 PM]: Verbose: Starting object: Search instance.

    [2/2/2007 1:28:26 PM]: Progress: [Search instance] 50 percent complete.

    Any ideas why either of these would not work?

    Thanks

    Justin

  • Further to my last post...

    I've discovered there is a "Search Backup and Restore (pause) application ......" entry in the Timer Job Definitions.

    Schedule Type: One-Time

  • Hi,

    I have a question about restoring a Project Server site.

    I've got the backups of the Web application(content db and all) and the project Web access site(4 project dbs).

    Now in order to restore the same environment, do I need to restore the web application first and then follow it up with the project web access site?

    I ask this because on restore the Project webaccess site does not ask for any web application to restore under.

    Does it restore under a web application with the same name(port) as it was under before?

  • Hello Treb,

    Thank you for the clear and helpful article.

    I follow your step by step instructions to restore Project Server 2007 from my backup. The only difference is that I put the backup in a local folder.

    Then I uninstalled Office project server completely, also deleted all the data in the local database folder.

    Then I reinstalled Project Server again using basic setup. I ensured SQL server account have full permissions on the data files and started full restore from the backup folder.

    Unfortunately I received errors that some objects already exists no matter I choose override option.

    Why is that. Please help, what I miss ?

    Here is one sample error :

    ----------------------------------------------------

    Error: Object SharedServices1 failed in event OnRestore. For more information, see the error log located in the backup directory.

    SPDuplicateObjectException: An object of the type Microsoft.Office.Server.Administration.SharedResourceProvider named

    "SharedServices1" already exists under the parent Microsoft.SharePoint.Administration.SPFarm named

    "SharePoint_Config_1ac3f072-9b11-4c02-9586-67016efc0c24".  Rename your object or delete the existing object.

    ------------------------------------------------

    I also have the same for PWA feature also.

    These objects also never reach completed status. They stay on "Completing" forever.

    I'll appreciate any information you can post.

    Thank you.

    Alexander Tzvetanov

  • Hi,

    Thank you for your article. I have a question about restoring a single project in project server 2007 ?

    Is there any substitute tool or procedure for the

    Restore Single Project Tool in Project 2003?

    Thank you in advance,

  • This post has been long comming. I recently spent some time with Samer Sawaya of SharePoint Recycle bin

  • If I wanted to copy one PWA configuration to another. How do you backup and restore the databases to another PWA provisioned site.  These steps looks like good for 1 to 1 backup and restore procedures.

  • Dear Everybody,

    After I finally hadn't succeeded to backup and restore MS Project server neither all Sharepoint nor only PWA using the above instructions. I called the trouble help me.

    Unfortunately this particular blog's issuer also doesn't help.

    So I finally ran filemon/regmon and setup the Basic configuration of PWA.

    As a result I made 2 .bat files for backup and restore of the basic configuration. In my case Windoes and also PWA was installed on drive D:. My backup folder is located at D:\ProjectServer\Backup.

    If any of you also have trouble with backup/restore MSProject server. Try my way.

    Regards

    Alexander Tzvetanov

    Follows the backup and restore scripts:

    backup.bat

    ----------------------------

    @ECHO **************************************************************************

    @ECHO * STOP ALL SERVICESS                                                     *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    @ECHO OFF

    SET BACKUP_PATH=D:\ProjectServer\Backup

    net stop "World Wide Web Publishing Service"

    net stop "Windows SharePoint Services Tracing"

    net stop "Windows SharePoint Services Timer"

    net stop "Windows SharePoint Services Search"

    net stop "Microsoft Office Project Server Events Service"

    net stop "Microsoft Office Project Server Queue Service"

    net stop "SQL Server (OFFICESERVERS)"

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * EXPORT REGISTRY KEYS                                                   *

    @ECHO *                                                                        *

    regedit /E %BACKUP_PATH%\WebExt.reg "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0"

    regedit /E %BACKUP_PATH%\Certs.reg "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SystemCertificates\My\Certificates"

    copy "%WINDIR%\system32\inetsrv\MetaBase.xml" "%BACKUP_PATH%\MetaBase.xml" /Y

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * COPY FILES                                                             *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    xcopy "%SYSTEMDRIVE%\Program Files\Microsoft Office Servers\*.*" %BACKUP_PATH%\ /S /F /Y /R

    md "%BACKUP_PATH%\Application Data"

    md "%BACKUP_PATH%\Application Data\Microsoft"

    md "%BACKUP_PATH%\Application Data\Microsoft\SharePoint"

    md "%BACKUP_PATH%\Application Data\Microsoft\SharePoint\Config"

    xcopy "%SYSTEMDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\*.*" "%BACKUP_PATH%\Application Data\Microsoft\SharePoint\Config\" /S /F /Y /R

    xcopy "%SYSTEMDRIVE%\Inetpub\wwwroot\wss\*.*" %BACKUP_PATH%\ /S /F /Y /R

    md "%BACKUP_PATH%\web server extensions"

    md "%BACKUP_PATH%\web server extensions\12"

    xcopy "%SYSTEMDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\12\*.*" "%BACKUP_PATH%\web server extensions\12\" /S /F /Y /R

    md "%BACKUP_PATH%\web server extensions\wpresources"

    xcopy "%SYSTEMDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources\*.*" "%BACKUP_PATH%\web server extensions\wpresources\" /S /F /Y /R

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * START ALL SERVICESS                                                    *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    net start "SQL Server (OFFICESERVERS)"

    net start "Windows SharePoint Services Tracing"

    net start "Windows SharePoint Services Timer"

    net start "Windows SharePoint Services Search"

    net start "Microsoft Office Project Server Events Service"

    net start "Microsoft Office Project Server Queue Service"

    net start "World Wide Web Publishing Service"

    restore.bat

    -----------------------------------------------

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * STOP ALL SERVICESS                                                     *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    @ECHO OFF

    SET BACKUP_PATH=D:\ProjectServer\Backup

    net stop "World Wide Web Publishing Service"

    net stop "HTTP SSL"

    net stop "IIS Admin Service"

    net stop "Windows SharePoint Services Tracing"

    net stop "Windows SharePoint Services Timer"

    net stop "Windows SharePoint Services Search"

    net stop "Microsoft Office Project Server Events Service"

    net stop "Microsoft Office Project Server Queue Service"

    net stop "SQL Server (OFFICESERVERS)"

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * COPY FILES                                                             *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    del "%WINDRIVE%\Program Files\Microsoft Office Servers\12.0" /Q /S /F

    rd "%WINDRIVE%\Program Files\Microsoft Office Servers\12.0" /S /Q

    md "%WINDRIVE%\Program Files\Microsoft Office Servers\12.0"

    xcopy %BACKUP_PATH%\12.0\*.* "%WINDRIVE%\Program Files\Microsoft Office Servers\12.0\" /S /F /Y /R

    del "%WINDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config" /Q /S /F

    rd "%WINDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config" /Q /S

    md "%WINDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config"

    xcopy "%BACKUP_PATH%\Application Data\Microsoft\SharePoint\Config\*.*" "%WINDRIVE%\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\" /S /F /Y /R

    del "%WINDRIVE%\Inetpub\wwwroot\wss\VirtualDirectories" /Q /S /F

    rd "%WINDRIVE%\Inetpub\wwwroot\wss\VirtualDirectories" /Q /S

    md "%WINDRIVE%\Inetpub\wwwroot\wss\VirtualDirectories"

    xcopy %BACKUP_PATH%\VirtualDirectories\*.* "%WINDRIVE%\Inetpub\wwwroot\wss\VirtualDirectories\" /S /F /Y /R

    del "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\12" /Q /S /F

    rd "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\12" /Q /S

    md "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\12"

    xcopy "%BACKUP_PATH%\web server extensions\12\*.*" "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\12\" /S /F /Y /R

    del "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources" /Q /S /F

    rd "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources" /Q /S

    md "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources"

    xcopy "%BACKUP_PATH%\web server extensions\wpresources\*.*" "%WINDRIVE%\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources\" /S /F /Y /R

    @ECHO Please setup registry and restore WEB environment

    regedit /D /S "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0"

    regedit /C /S %BACKUP_PATH%\WebExt.reg

    @REM regedit /D "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SystemCertificates\My\Certificates"

    regedit /C /S %BACKUP_PATH%\Certs.reg

    copy "%BACKUP_PATH%\MetaBase.xml" "%WINDIR%\system32\inetsrv\MetaBase.xml" /Y

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * START ALL SERVICESS                                                    *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    net start "SQL Server (OFFICESERVERS)"

    net start "Windows SharePoint Services Tracing"

    net start "Windows SharePoint Services Timer"

    net start "Windows SharePoint Services Search"

    net start "Microsoft Office Project Server Events Service"

    net start "Microsoft Office Project Server Queue Service"

    net start "HTTP SSL"

    net start "IIS Admin Service"

    net start "World Wide Web Publishing Service"

  • hi there:

    I have two error during the restore.

    The backup of a single site don´t have problems.

    When I did the restore in a new stand alone Server, I have two error:

    Error 1: Object My site failed in event OnRestore. For more information, see the error log located in the backup

    directory.

    ArgumentException: The IIS Web Site you have selected is in use by SharePoint.

    You must select another port or hostname.

    Error 2: Object EDF_DB failed in event OnRestore.

    SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005,

    this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

    (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Can Anybody help me?

    regards

  • Pedro Medina where you able to find the solution for your problem mentioned above as i am having the same issue

    Thanks,

    Shraddha

  • Dear All,

    i m Varun and i m working in a Private firm. i have to make ready project server but i dont have any idea bout that. any one of yall can mail me the installation steps of MSP 2007 Server and Professional. also if possible can yall mail me how to connect MSP Client with the MSP Server.

    yall help will be very kindful. Pls mail the documents on this ID: varun.palija@kalpataru.com

    regards

    Varun.

  • hi all

    i have already backed up my PWA sites successfully, using way interoduced above, but i have one problem, i cant restore my back up in another SSP!

    please help on this issue

    my email is alen.martynov@gmail.com

Page 1 of 3 (43 items) 123