Recovering the entire farm in Project Server 2007

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

When recovering an entire farm, the basic sequence of events is:

  1. Replace hardware

  2. Install software

  3. Deploy Project Web Access

  4. Restore databases

  5. Connect the original SharePoint Products and Technologies configuration database to the new deployment

Important

The procedures in this article require that all servers have the same server names as those in the original deployment and that the SQL Server instance name also be the same as that in the original deployment. Failure to use the same server names can lead to failures in the SharePoint Products and Technologies farm and may leave your deployment in an unsupported state.

Recovering an Office Project Server 2007 farm with Windows SharePoint Services

Use the following procedure to recover a Microsoft Office Project Server 2007 farm that uses Windows SharePoint Services 3.0.

Recover an Office Project Server 2007 farm with Windows SharePoint Services

  1. Follow the basic recovery steps in Recovering computers in your deployment in Project Server 2007 for each computer in your farm.

  2. Install SQL Server on the appropriate computer.

  3. Install Office Project Server 2007 on the appropriate computer. Choose the Advanced install and Complete Install options.

  4. In the SharePoint Products and Technologies Configuration Wizard, choose to create a new farm.

  5. Specify the same instance of SQL Server from your original deployment, but change the default Windows SharePoint Services configuration database name from SharePoint_Config to SharePoint_Config_temp.

  6. Restore each database in your deployment, making sure to keep the same database names from the original deployment.

  7. Restore transaction logs for those databases that use the Full Recovery model.

  8. Recover databases that you are synchronizing to a named mark or to the point of failure if full transaction log backups are available for all databases.

  9. On the computer running Office Project Server 2007, open a Command Prompt window.

  10. Navigate to \Program files\Common files\Microsoft shared\Web server extensions\12\bin.

  11. Use psconfig.exe to configure Office Project Server 2007 to use your original configuration database:

    psconfig.exe -cmd configdb -connect -server <SQL Server instance> -database <original config db> -user <domain\user> -password <password>

  12. When psconfig.exe finishes, run the SharePoint Products and Technologies Configuration Wizard with the default options.

Recovering an Office Project Server 2007 farm with Office SharePoint Server 2007

Use the following procedure to recover a Office Project Server 2007 farm that uses Microsoft Office SharePoint Server 2007.

Recover an Office Project Server 2007 farm with Office SharePoint Server 2007

  1. Follow the basic recovery steps in Recovering computers in your deployment in Project Server 2007 for each computer in your farm.

  2. Install SQL Server on the appropriate computer.

  3. Install Office SharePoint Server 2007 on the appropriate computer. Choose the Advanced install and Complete Install options.

  4. In the SharePoint Products and Technologies Configuration Wizard, choose to create a new farm.

  5. Specify the same instance of SQL Server from your original deployment, but change the default Office SharePoint Server configuration database name from SharePoint_Config to SharePoint_Config_temp.

  6. Install Office Project Server 2007 on the computer running Office SharePoint Server 2007.

  7. Restore each database in your deployment, making sure to keep the same database names from the original deployment.

  8. Restore transaction logs for those databases that use the Full Recovery model.

  9. Recover databases that you are synchronizing to a named mark or to the point of failure if full transaction log backups are available for all databases.

  10. When all the databases have been restored, on the computer running Office Project Server 2007, open a Command Prompt window.

  11. Navigate to \Program files\Common files\Microsoft shared\Web server extensions\12\bin.

  12. Use psconfig.exe to configure Office Project Server 2007 to use your original configuration database:

    psconfig.exe -cmd configdb -connect -server <SQL Server instance> -database <original config db> -user <domain\user> -password <password>

  13. When psconfig.exe finishes, run the SharePoint Products and Technologies Configuration Wizard with the default options.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.

See Also

Concepts

Enterprise disaster recovery for Project Server 2007
Recovering your deployment in Project Server 2007