Disaster recovery procedure for Microsoft Office SharePoint Server 2007 using Symantec Backup Exec for Windows Servers, version 11d or later

Article:TECH53313  |  Created: 2010-01-11  |  Updated: 2013-03-05  |  Article URL http://www.symantec.com/docs/TECH53313
Article Type
Technical Solution

Product(s)

Subject

Issue



Disaster recovery procedure for Microsoft Office SharePoint Server 2007 using Symantec Backup Exec for Windows Servers, version 11d or later


Solution



This procedure is intended for an all-in-one Sharepoint server disaster recovery or the recovery of a multi-server farm database server.  Normally if other servers in a multi-server Sharepoint Farm require restore, Sharepoint is still functional and a normal operating system restore can be performed, followed by restoring the required Sharepoint data. In order to perform the steps described in this document to restore a Sharepoint environment, the following must be in place:
 

Symantec Backup Exec (tm) for Windows Servers with the SharePoint Agent is installed.
The latest backup of the SharePoint Portal Server that is to be recovered is available. This backup must include the Sharepoint SQL instance system databases, Master, Model, and MSDB.

The operating system on the SharePoint server(s) must be recovered first. Follow the steps described in the Symantec Backup Exec for Windows Servers Administrator's Guide for recovering the operating system of the Sharepoint Server(s).   Either a manual method of restore for the Operating System may be used or the Intelligent Disaster Recovery (IDR) option may be used. 

Upon the recovery of the Windows server (after the last reboot) the SharePoint and SQL software will be present but not functional. 

Repairing the Sharepoint SQL instance and restoring SharePoint data
NOTE: if the IDR process has been used to restore the operating system of the Sharepoint server,the following step 1 is not necessary as the SQL instance will already be up and running on completion of the IDR restore..

1. This restore procedure assumes that backups have been made of the Sharepoint SQL system databases, Master, Model, and MSDB.  In order to get the SQL server running to restore the Sharepoint SQL databases, the Master and Model databases must be put in place.  The easiest method is to simply rename the offline copies of the Master and Model databases that Backup Exec creates during normal SQL backups.  Locate the following database files in the Sharepoint SQL Data folder, remove the Read-Only attribute, and rename them as shown. 

Offline DB/Log Filename Rename To                    
MASTER$4IDR MASTER.MDF
MASTLOG$4IDR MASTLOG.LDF
MODEL$4IDR MODEL.MDF
MODELLOG$4IDR MODELLOG.LDF

Once these database files are renamed and in place, start the SQL server service. 

2. Be sure the media containing the Sharepoint server backups is available to Backup Exec on disk or by inserting the tape(s) in to the drive / library.

3. If necessary, from the 'Devices' tab, perform an Inventory job and then a Catalog job on the media containing the latest backup required for the SharePoint Server recovery. These functions can be performed by right-clicking on the media containing the backup job(s) and selecting 'Inventory...' or 'Catalog media...'.

4. On the navigation bar, click Restore to create a new restore job.
     A. Select the backup set(s) for the 'msdb' database for the SQL instance used by SharePoint. 
     B. Choose the option 'Leave database ready to use. Additional transaction logs cannot be restored' under Settings | Microsoft SQL in the Restore Job Properties. 
     C. Be sure that the resource credentials supplied in the job are appropriate for the SQL server then submit and run the restore job to completion.

5. Create another restore job and select the backup sets for all SharePoint resources in the farm, except for the following:

    ConfigurationV3-DB database resource
    Global Settings resource (if applicable)
    Single Sign-on database resource (if applicable)
    
A. Check the 'Bring restored databases online' and 'Reconnect previous database links' options under Settings | Microsoft Sharepoint in the Restore Job Properties
     Note:  With Backup Exec 2010 R2 or later, also select the 'Replace existing database' option.
B. Confirm the resource credentials for the job then submit and run the restore job, allowing it to run to completion. 

Important Note:
Because the Sharepoint environment is not yet functional, the restore of the Sharepoint SQL databases may fail.  The expected error message in the completed job log will be:

Connection to the restore target has been lost.  Operation canceled.

This error may be present for each database restored but only indicates no connection to the Sharepoint environment could be obtained.  In a Disaster Recovery scenario, if no connection can be made to Sharepoint, the database restore is performed anyway.  If the restore job fails in this manner, it is important to review the job log to confirm that data has been restored for each database selected for restore.  This confirmation is performed by viewing the 'Restore Set Summary' for each database in the Job Log to view the 'Processed x,xxx,xxx bytes...' value.  The number of bytes should equal or approximate the expected database size and not be 0.

6. Create another new restore job.

A. select the backup set(s) for the SharePoint 'ConfigurationV3-DB' resource.
B. Check the 'Bring restored databases online' and 'Reconnect previous database links' options under Settings | Microsoft Sharepoint in the Restore Job Properties. 
     Note:  With Backup Exec 2010 R2 or later, also select the 'Replace existing database' option.
C. Again, verify the resource credentials are correct then submit and run the restore job.

7. Restart the SharePoint server when the restore of the configuration database completes.

8. When the SharePoint server has finished restarting, create a new restore job and select the backup sets for the 'Global Settings' resource, and the 'Single Sign-on' database resource (if applicable).
 

A. Check the 'Bring restored databases online' and 'Reconnect previous database links' options under Settings | Microsoft Sharepoint in the Restore Job Properties.

Note: It is recommended to perform a new backup as soon as possible after the recovery.




Legacy ID



290873


Article URL http://www.symantec.com/docs/TECH53313


Terms of use for this information are found in Legal Notices