Recovering SharePoint 2007 data after a disaster

You can use the SharePoint Agent to recover a SharePoint server after a hard drive failure. Before you recover SharePoint data, you must recover the SharePoint server’s operating system.

You can use Backup Exec’s Intelligent Disaster Recovery Option or you can manually recover the server’s operating system.

See About the Intelligent Disaster Recovery Option.

See About manual disaster recovery of Windows computers.

After the Windows server is recovered, you can recover SharePoint 2007 data. Complete the actions in the table in successive order to recover the SharePoint data.

Table: To recover SharePoint 2007 data after a disaster

Step

Action

Notes

Step 1

Recover the master database and the model database for the SQL instances that SharePoint uses. You must perform this step if you manually recovered the server’s operating system.

Skip this step if you used Backup Exec’s Intelligent Disaster Recovery Option to recover the server’s operating system.

See About recovering SQL manually.

Step 2

Inventory the media to be recovered.

See Inventorying media in a device.

Step 3

Catalog the media to be recovered.

See Creating a new catalog.

Step 4

Restore the msdb databases for any SQL instances that SharePoint uses.

Select the backup sets that contain the msdb databases for the SQL instances that SharePoint uses.

Configure the following Microsoft SQL restore options:

  • Select Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  • Select Overwrite the existing database.

See Restoring data by setting job properties.

Step 5

Restore SharePoint farm resources.

Select the backup sets for all SharePoint resources in the farm except for the following:

  • Configuration V3-DB database resource

  • Global Settings resource

  • Single Sign-on database resource (if applicable)

Configure the following Microsoft SharePoint restore options:

  • Select Bring restored databases online.

  • Select Reconnect previous database links.

  • Select Replace existing database.

See Restoring data by setting job properties.

Note:

Some of the remaining restore jobs may fail because communication with the SharePoint server has not been fully established yet. This behavior is expected. Proceed with the recovery process until all steps are complete.

Step 6

Restore the SharePoint Configuration V3-DB resource.

Select the backup sets for the SharePoint Configuration V3-DB resource.

Configure the following Microsoft SharePoint restore options:

  • Select Bring restored databases online.

  • Select Reconnect previous database links.

  • Select Replace existing database.

See Restoring data by setting job properties.

Step 7

Restart the SharePoint server.

After the restore job is complete, restart the SharePoint server. Then proceed to the next step.

Step 8

Restore remaining SharePoint resources.

Select the backup sets for the SharePoint Global Settings and Single Sign-on database resources, if necessary.

See Restoring data by setting job properties.

Step 9

Back up the SharePoint server.

When the disaster recovery is complete, Symantec recommends that you perform a backup job as soon as possible.

See Creating a backup job by setting job properties.

Recovering SharePoint 2007 data after a disaster