This topic has not yet been rated Rate this topic

Recovering the entire farm in Project Server 2007

Updated: 2009-03-05

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

Replace hardware
Install software
Deploy Project Web Access
Restore databases
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.

Follow the basic recovery steps in Recovering computers in your deployment in Project Server 2007 for each computer in your farm.
Install SQL Server on the appropriate computer.
Install Office Project Server 2007 on the appropriate computer. Choose the Advanced install and Complete Install options.
In the SharePoint Products and Technologies Configuration Wizard, choose to create a new farm.
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.
Restore each database in your deployment, making sure to keep the same database names from the original deployment.
Restore transaction logs for those databases that use the Full Recovery model.
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.
On the computer running Office Project Server 2007, open a Command Prompt window.
Navigate to \Program files\Common files\Microsoft shared\Web server extensions\12\bin.

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

Copy

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

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

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

Follow the basic recovery steps in Recovering computers in your deployment in Project Server 2007 for each computer in your farm.
Install SQL Server on the appropriate computer.
Install Office SharePoint Server 2007 on the appropriate computer. Choose the Advanced install and Complete Install options.
In the SharePoint Products and Technologies Configuration Wizard, choose to create a new farm.
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.
Install Office Project Server 2007 on the computer running Office SharePoint Server 2007.
Restore each database in your deployment, making sure to keep the same database names from the original deployment.
Restore transaction logs for those databases that use the Full Recovery model.
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.
When all the databases have been restored, on the computer running Office Project Server 2007, open a Command Prompt window.
Navigate to \Program files\Common files\Microsoft shared\Web server extensions\12\bin.

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

Copy

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

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

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