Redirecting the restore of a SharePoint Server Web application content database to an alternate SQL instance
You can redirect a SharePoint Web application content database to an alternate SQL instance to take advantage of SharePoint data recovery from an unattached content database. The target database must be a new database.
For information on how to redirect individual items to a file path, see the following topic:
See Redirecting individual SharePoint items to a file path (SharePoint 2010).
To redirect the restore of a SharePoint Server database to an alternate SQL instance
- Open the Backup, Archive, and Restore interface.
- Click File > Select Files and Folders to Restore > from Normal Backup.
- Select the MS-SharePoint policy type.
- From the NetBackup History pane, select the full backup image that contains the objects you want to restore.
- In the All Folders pane, expand Microsoft SharePoint Resources.
Note:
When you select items to restore, do not check the checkbox for an item in the All folders pane. Only check the checkbox for an item in the Contents of pane.
- In the Contents of pane, select the Web application content database to redirect.
The following image shows a SharePoint 2010 restore.
- Click Actions > Restore.
- In the Restore Marked Files dialog box, click the Microsoft SharePoint tab.
- Click Redirect SharePoint Resources.
- Select Alternate SQL Instance.
- In the SQL Server\Instance box, type the name of the SQL server and the instance name to which you want to redirect the Web application content database.
- In the Target Database box, indicate the name of the target database.
For information on other restore options in this dialog box, see the following topic:
- Click Start Restore.
