Restore Data - SharePoint Server - How To

Topics | How To | Full System Restore | Troubleshoot | Related Topics

Restore a Site Collection

Restore an Individual Site

Restore a WSS Web Application Content Database

Restore a WSS Search

Restore a Service Application

Restore a Service Application Proxy

Restore a Shared Service Provider

Restore a Single Sign-on Database

Restore a Project Server Shared Service Provider

Restore a Search Server Shared Service Provider

Restore SharePoint Data Secured by the SQL iDataAgent in a Server Farm

Microsoft Office SharePoint Portal Server 2003

Restore a Site Collection

Restore a Teamsite Database

Restore a Portal Site

Restore a Site Content Database

Restore a Site Index

Restore a Single Sign-on Database

Restore a Webstorage System Database

Restore a Site Collection

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Collection database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Site Collection.
3. From the Restore Options dialog box, enter the required information in the Site Collection tab.
4. Continue with the restore procedure.

Restore an Individual Site

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• Using this procedure will restore all site permissions and all versions of the site.
• Before backing up the site, the bSiteExportEnabled registry key must have been set to 1.

Required Capability: See Capabilities and Permitted Actions

To restore an individual Site from a Database backup set:

1. Right-click a SharePoint database backup set and select Browse Backup Data. See Browse and Restore for step-by-step instructions.
2. Click OK.
3. From the Browse Data window, select Site or select Site under Site Collections if the Site Collection was backed up.
4. Click Recover All Selected...
5. In Report Options dialog box, click the Site tab.
6. Select the site to restore from the list and click Overwrite URL. The existing site will be deleted and restored only when Overwrite URL is selected. If the site cannot be deleted, the content will be merged into an existing site.

   For out-of-place restores, the top-level sites will be restored as top-level sites and subsites will be restored as subsites. Set the bSiteImportRetainObjectIdentity to 1 to override the object identity if the Site URL path is similar to the original one for out-of-place restore operations.

7. Click OK.

Restore a WSS Web Application Content Database

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Web Application Content Database was removed from the Virtual Server but the database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).
• If the Web Application was deleted, or if SharePoint was removed from the IIS web site with the option "Delete IIS Web sites", or if an IIS web site does not exist, then the IIS web site should be manually created in IIS.
• If SharePoint was removed from an IIS web site, delete the WSS Web Application prior to restoring the WSS Web Application Content Database.

Required Capability: See Capabilities and Permitted Actions

To restore the Windows SharePoint Services (WSS) Web Application:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the WSS Web Application node and select Web Application Database. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options Windows SharePoint Services Web App Tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If SharePoint was removed from an IIS web site, delete the WSS Web Application prior to restoring the WSS Web Application Content Database.
• If the Web Application was deleted or SharePoint was removed from the IIS web site with the option "Delete IIS Web sites", then the IIS web site should be manually created in IIS.
• To preserve the original Web Application name, set the sOwnerLogin and sOwnerEmail registry keys, and then restore the WSS Web Application Content Database with the Extend URL option selected.

Required Capability:: See Capabilities and Permitted Actions

To restore the WSS Web Application:

1. Restore the WSS Web Application Database using the SQL iDataAgent.  Refer to Recovering Database for step-by-step instructions. [Do not restore the SharePoint Configuration Database].
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the WSS Web Application node and select Web Application Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Windows SharePoint Services Web App Tab.
5. Continue with the restore procedure.
6. For SharePoint 2010: After you restore a Web Application with the Extend URL option, you must do the following:
   1. Open IIS Manager.
   2. Under Web Site, select the restored Web Application, and then check the Application Pool name assigned to it.
   3. If the Application Pool credentials are set to NetworkService, then stop the Web Site.
   4. Select a different Application Pool with Managed Account credentials.
   5. Start the Web Site.

Restore a WSS Search

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the WSS Search database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).
• In Windows Services, stop the Windows SharePoint Services Search service and delete WSS Search Index that is typically located under ..\Microsoft Office Servers\12.0\Data Application.

Required Capability: See Capabilities and Permitted Actions

To restore a WSS Search:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select the SP Search node. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options WSS Search DB tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• In Windows Services, stop the Windows SharePoint Services Search service and delete WSS Search Index that is typically located under ..\Microsoft Office Servers\12.0\Data Application.

Required Capability: See Capabilities and Permitted Actions

To restore a WSS Search:

1. Restore the WSS Search Database using the SQL iDataAgent. Refer to Recovering a Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, select SP Search. Click Recover all Selected.
4. From the Restore Options dialog box, enter the required information in the Restore Options WSS Search DB tab.
5. Continue with the restore procedure.

Restore a Service Application

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• This procedure applies only to database backup sets.
• For a successful restore, ensure that the SQL Server instance service account and SharePoint 2010 Timer service account are switched to Local System. Once the restore is finished, you can switch back to using the previous accounts (e.g., Network Service).
• To restore Microsoft Office Project Server 2010 Project Web Access (PWA) Sites, follow the procedure below. These sites cannot be restored using the Restore a SharePoint Server Site Collection procedure or the Restore a 2007 Project Web Access (PWA) Site procedure.

Required Capability: See Capabilities and Permitted Actions

To restore a Service Application:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Service Application.
3. From the Restore Options dialog box, enter the required information in the Service Application tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• This procedure applies only to database backup sets.

Required Capability: See Capabilities and Permitted Actions

To restore a Service Application:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Service Application.
3. From the Restore Options dialog box, enter the required information in the Service Application tab.
4. Continue with the restore procedure.

Restore a Service Application Proxy

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• This procedure applies only to database backup sets.
• For a successful restore, ensure that the SQL Server instance service account and SharePoint 2010 Timer service account are switched to Local System. Once the restore is finished, you can switch back to using the previous accounts (e.g., Network Service).
• To restore Microsoft Office Project Server 2010 Project Web Access (PWA) Sites, follow the procedure below. These sites cannot be restored using the Restore a SharePoint Server Site Collection procedure or the Restore a 2007 Project Web Access (PWA) Site procedure.

Required Capability: See Capabilities and Permitted Actions

To restore a Service Application Proxy:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Service Application Proxy.
3. From the Restore Options dialog box, enter the required information in the Service Application Proxy tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• This procedure applies only to database backup sets.

Required Capability: See Capabilities and Permitted Actions

To restore a Service Application Proxy:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Service Application Proxy.
3. From the Restore Options dialog box, enter the required information in the Service Application Proxy tab.
4. Continue with the restore procedure.

Restore a Site Collection

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Collection database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Site Collection.
3. From the Restore Options dialog box, enter the required information in the Site Collection tab.
4. Continue with the restore procedure.

Restore a WSS Web Application Content Database

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Web Application Content Database was removed from the Virtual Server but the database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).
• If the Web Application was deleted, or if SharePoint was removed from the IIS web site with the option "Delete IIS Web sites", or if an IIS web site does not exist, then the IIS web site should be manually created in IIS.
• If SharePoint was removed from an IIS web site, delete the WSS Web Application prior to restoring the WSS Web Application Content Database.

Required Capability: See Capabilities and Permitted Actions

To restore the Windows SharePoint Services (WSS) Web Application:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the WSS Web Application node and select Web Application Database. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options Windows SharePoint Services Web App Tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If SharePoint was removed from an IIS web site, delete the WSS Web Application prior to restoring the WSS Web Application Content Database.
• If the Web Application was deleted or SharePoint was removed from the IIS web site with the option "Delete IIS Web sites", then the IIS web site should be manually created in IIS.
• To preserve the original Web Application name, set the sOwnerLogin and sOwnerEmail registry keys, and then restore the WSS Web Application Content Database with the Extend URL option selected.

Required Capability:: See Capabilities and Permitted Actions

To restore the WSS Web Application:

1. Restore the WSS Web Application Database using the SQL iDataAgent.  Refer to Recovering Database for step-by-step instructions. [Do not restore the SharePoint Configuration Database].
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the WSS Web Application node and select Web Application Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Windows SharePoint Services Web App Tab.
5. Continue with the restore procedure.
6. For SharePoint 2010: After you restore a Web Application with the Extend URL option, you must do the following:
   1. Open IIS Manager.
   2. Under Web Site, select the restored Web Application, and then check the Application Pool name assigned to it.
   3. If the Application Pool credentials are set to NetworkService, then stop the Web Site.
   4. Select a different Application Pool with Managed Account credentials.
   5. Start the Web Site.

Restore a WSS Search

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the WSS Search database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).
• In Windows Services, stop the Windows SharePoint Services Search service and delete WSS Search Index that is typically located under ..\Microsoft Office Servers\12.0\Data Application.

Required Capability: See Capabilities and Permitted Actions

To restore a WSS Search:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select the SP Search node. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options WSS Search DB tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• In Windows Services, stop the Windows SharePoint Services Search service and delete WSS Search Index that is typically located under ..\Microsoft Office Servers\12.0\Data Application.

Required Capability: See Capabilities and Permitted Actions

To restore a WSS Search:

1. Restore the WSS Search Database using the SQL iDataAgent. Refer to Recovering a Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, select SP Search. Click Recover all Selected.
4. From the Restore Options dialog box, enter the required information in the Restore Options WSS Search DB tab.
5. Continue with the restore procedure.

Restore a Shared Service Provider

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• Delete the Shared Services Provider if it is not default. If it is the default and others do not exist, create new Shared Services Provider for temporal usage and set it as default. 
• Delete old Shared Services Provider.
• Delete the WSS Web Application that hosted the Shared Services Provider.

Required Capability: See Capabilities and Permitted Actions

To restore a Shared Service Provider:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. Follow the procedure Restore a SharePoint Server WSS Web Application Content Database to restore the WSS Web Application that hosted the Shared Services Provider.
3. Using stsadm.exe command, delete site ../ssp/admin from restored Web Application. For example, stsadm -o deletesite -url http://<URL of WebApp Hosting SSP>/ssp/admin.
4. From the Browse Data window, expand the Shared Services Provider, select Shared Services.  Click Recover all Selected.
5. From the Restore Options dialog box, enter the required information in the Restore Options Shared Service Provider DB, Search Shared DB, and Search Index Server tabs.
6. Continue with the restore procedure.
7. Set restored Shared Services Provider as default if necessary and re-associate regional Web Application back to it. Delete Shared Services Provider for temporal usage if it was created.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Shared Service Provider:

1. Follow the procedure Restore a SharePoint Server WSS Web Application Content Database to restore the WSS Web Application that hosted the Shared Services Provider.
2. Using stsadm.exe command, delete site ../ssp/admin from restored Web Application. For example, stsadm -o deletesite -url http://<URL of WebApp Hosting SSP>/ssp/admin.
3. Restore the Shared Services Provider Databases using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
4. From the Browse Data window, expand the Shared Services Provider, select Shared Services.  Click Recover all Selected.
5. From the Restore Options dialog box, enter the required information in the Restore Options Shared Service Provider DB, Search Shared DB, and Search Index Server tabs.
6. Continue with the restore procedure.
7. Set restored Shared Services Provider as default if necessary and re-associate regional Web Application back to it. Delete Shared Services Provider for temporal usage if it was created.

Restore a Single Sign-on Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Single Sign-on database / Stand-alone or Single server with SQL Server Deployments:

1. Stop the Microsoft Single Sign-on Service.
2. If the SSO SQL database still exists, delete it.
3. Start the Microsoft Single Sign-on Service.
4. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
5. From the Browse Data window, select Single Sign-on Database.
6. From the Restore Options dialog box, enter the required information in the Single Sign-on Database tab.
7. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Single Sign-on database / Server Farm (Small, Medium, Large):

1. Stop the Microsoft Single Sign-on Service on All Servers in the farm.
2. Restore the Single Sign-On Database on the SQL Server using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions.
3. Start the Microsoft Single Sign-on Service on the Job Server.
4. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
5. From the Browse Data window, select Single Sign-on Database.
6. From the Restore Options dialog box, enter the required information in the Single Sign-on Database tab.
7. Continue with the restore procedure.
8. Restart the Microsoft Single Sign-on Service on the Job Server.
9. Start the Microsoft Single Sign-on Service on all other Servers in the Farm.

Restore a Project Server Shared Service Provider

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• Project Web Access (PWA) sites cannot be restored using the Restore a SharePoint Server Site Collection procedure. Instead, follow the procedure outlined below.
• These Project Server databases can typically be restored: Project server_Archive, Project server_Draft, Project server_Published, and Project server_Reporting. These cannot be distributed over multiple subclient. They need to be backed up and restored together as they belong to the same PWA (Project Web Access) Site.

Required Capability: See Capabilities and Permitted Actions

To restore a Project Web Access (PWA) Site:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select the Project Server Application node. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options Project Server Application tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Project Web Access (PWA) Site:

1. Restore the Project Server Database using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, select Project Server Application. Click Recover all Selected.
4. From the Restore Options dialog box, enter the required information in the Restore Options Project Server Application tab.
5. Continue with the restore procedure.

Restore a Search Server Shared Service Provider

Stand-alone Deployment

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Shared Service Provider:

1. At the Databases backup set level, begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the Shared Services Provider, select SharedServices.  Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options Shared Service Provider DB, Search Shared DB, and Search Index Server tabs.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Shared Service Provider:

1. Restore the Shared Services Provider Databases using the SQL iDataAgent. Refer to Recovering a Database for step-by-step instructions
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the Shared Services Provider, select SharedServices.  Click Recover all Selected.
4. From the Restore Options dialog box, enter the required information in the Restore Options Shared Service Provider DB, Search Shared DB, and Search Index Server tabs.
5. Continue with the restore procedure.

Restore a Site Collection

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Collection database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Site Collection.
3. From the Restore Options dialog box, enter the required information in the Site Collection tab.
4. Continue with the restore procedure.

Restore a Teamsite Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Teamsite database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).

Required Capability: See Capabilities and Permitted Actions

To restore a Teamsite database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select the Teamsite Database.
3. From the Restore Options dialog box, enter the required information in the Restore Options Teamsite Databases tab.
4. Continue with the restore procedure.
5. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
6. Restart IIS.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Teamsite database:

1. Restore the Teamsite Databases using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, select the Teamsite Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Teamsite Databases tab.
5. Continue with the restore procedure.
6. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
7. Restart IIS.

Microsoft Office SharePoint Portal Server 2003 Procedures

Restore a Site Collection

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Collection database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Site Collection.
3. From the Restore Options dialog box, enter the required information in the Site Collection tab.
4. Continue with the restore procedure.

Restore a Teamsite Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Teamsite database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).

Required Capability: See Capabilities and Permitted Actions

To restore a Teamsite database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select the Teamsite Database.
3. From the Restore Options dialog box, enter the required information in the Restore Options Teamsite Databases tab.
4. Continue with the restore procedure.
5. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
6. Restart IIS.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore a Teamsite database:

1. Restore the Teamsite Databases using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, select the Teamsite Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Teamsite Databases tab.
5. Continue with the restore procedure.
6. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
7. Restart IIS.

Restore a Portal Site

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the portal site databases were not deleted from the SQL Instance, delete them before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).
• Disconnect any Virtual Servers that are mapped to the portal site.

Required Capability: See Capabilities and Permitted Actions

To restore a Portal Site:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the Portal Site node, select Portal Site, and deselect the Index and any Site Content Databases; these should be restored after the Portal Site restore is complete. Click Recover all Selected.
3. From the Restore Options dialog box, enter the required information in the Restore Options Site Databases tab.
4. Continue with the restore procedure.
5. When the restore completes, perform the Site Content Database restore.
6. When the Site Content database restore completes, perform the Site Index restore.
7. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
8. Restart IIS.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• Disconnect any Virtual Servers that are mapped to the portal site.

Required Capability: See Capabilities and Permitted Actions

To restore a Portal Site:

1. Restore the Portal Site Databases using the SQL iDataAgent to Recovering a Database. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the Portal Site node, select Portal Site, and deselect the Index and any Site Content Databases; these should be restored after the Portal Site restore is complete. Click Recover all Selected.
4. From the Restore Options dialog box, enter the required information in the Restore Options Site Databases tab.
5. Continue with the restore procedure.
6. When the restore completes, perform the Site Content Database restore.
7. When the Site Content database restore completes, perform the Site Index restore.
8. Restore the directory for the IIS Virtual Server using the File System iDataAgent.
9. Restart IIS.

Restore a Site Content Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Site Content Database restore is part of Portal Site Restore do not restore the Site Content database before the Portal Site Restore.
• If the Site Content Database was removed from the Virtual Server but the database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).

Required Capability: See Capabilities and Permitted Actions

To restore the Site Content database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the Portal Site node and select Site Content Database.
3. From the Restore Options dialog box, enter the required information in the Restore Options Site Content Databases tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Site Content Database restore is part of Portal Site Restore do not restore the Site Content database before the Portal Site Restore.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Content database:

1. Restore the Site Content Databases using the SQL iDataAgent. Refer to Recovering a Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the Portal Site node and select Site Content Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Site Content Databases tab.
5. Continue with the restore procedure.

Restore a Site Index

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• Restore the Portal Site before restoring the Index.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Index:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the Portal Site node and select the Index.
3. From the Restore Options dialog box, enter the required information in the Restore Options Site Index tab.
4. Continue with the restore procedure.

Restore a Single Sign-on Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Single Sign-on database / Stand-alone or Single server with SQL Server Deployments:

1. Stop the Microsoft Single Sign-on Service.
2. If the SSO SQL database still exists, delete it.
3. Start the Microsoft Single Sign-on Service.
4. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
5. From the Browse Data window, select Single Sign-on Database.
6. From the Restore Options dialog box, enter the required information in the Single Sign-on Database tab.
7. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

Required Capability: See Capabilities and Permitted Actions

To restore the Single Sign-on database / Server Farm (Small, Medium, Large):

1. Stop the Microsoft Single Sign-on Service on All Servers in the farm.
2. Restore the Single Sign-On Database on the SQL Server using the SQL iDataAgent. Refer to Recovering Database for step-by-step instructions.
3. Start the Microsoft Single Sign-on Service on the Job Server.
4. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
5. From the Browse Data window, select Single Sign-on Database.
6. From the Restore Options dialog box, enter the required information in the Single Sign-on Database tab.
7. Continue with the restore procedure.
8. Restart the Microsoft Single Sign-on Service on the Job Server.
9. Start the Microsoft Single Sign-on Service on all other Servers in the Farm.

Restore a Webstorage System Database

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• The Document Management component for Microsoft Office SharePoint Portal Server 2003 must be installed on the server.
• On the "List and Manage Document Libraries" page of the SharePoint Portal Server Central Administration, disconnect any existing document libraries.

Required Capability: See Capabilities and Permitted Actions

To restore the Webstorage System database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, select Webstorage System Database.
3. Continue with the restore procedure.
4. After successfully completing a restore, any restored document libraries that were disconnected or deleted will come back with a Portal Association value of "None". To associate the library with a Portal Site, disconnect and then reconnect the library manually.

Restore SharePoint Data with SQL Server RBS Enabled in a Server Farm

To restore unstructured data in RBS, which was either backed up by SnapProtect or the SQL Server iDataAgent, in a server farm configuration follow the steps given below:

1. Ensure that the RBS is enabled on the destination instance.
2. From the CommCell Browser, navigate to the SQL agent | Backup set and click All Tasks and then click Browse.
3. Run a browse operation.
4. From the Browse window, Select Objects From the Browse Window for Restore.
5. After completing your selections, you can either start an immediate restore or schedule the restore.
   • If you want to schedule the job, click the Job Initiation tab from the Restore Options dialog box, click Schedule, schedule the job, and then click OK.
   • If you want to run the job now, accept or click Run Immediately in the same tab and then click OK.
6. From the CommCell Browser, navigate to the SharePoint agent | Database and click All Tasks and then click Browse.
7. Run a browse operation.
8. From the Browse window, Select Objects From the Browse Window for Restore.
9. After completing your selections, you can either start an immediate restore or schedule the restore.
   • If you want to schedule the job, click the Job Initiation tab from the Restore Options dialog box, click Schedule, schedule the job, and then click OK.
   • If you want to run the job now, accept or click Run Immediately in the same tab and then click OK.
10. For Out-of-Place, ensure that the RBS is installed on the destination client.
11. From SharePoint Management Shell type the following commands to re-attach the restored content database with web application:

    $cdb = Get-SPContentDatabase <Content database Name>

    $rbss = $cdb.RemoteBlobStorageSettings

    $rbss.Installed()

    $rbss.Enable()

    $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])