Restore Data - SharePoint Server - How To

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

SharePoint Server 2003 and 2007 (Common)

Restore a SharePoint Server Site Collection

Restore a SharePoint Server Single Sign-on Database

SharePoint Server 2007

Restore a SharePoint Server WSS Web Application Content Database

Restore a SharePoint Server Shared Service Provider

Restore a SharePoint Server WSS Search

SharePoint Portal Server 2003

Restore a SharePoint Server Portal Site

Restore a SharePoint Server Site Content Database

Restore a SharePoint Server Site Index

Restore a SharePoint Server Teamsite Database

Restore a SharePoint Server Webstorage System Database

Common Procedures

Restore a SharePoint Server 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 SharePoint Server 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 to Recover SQL Server Databases.
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.

SharePoint Server 2007 Procedures

Restore a SharePoint Server 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.

Required Capability: See Capabilities and Permitted Actions

To restore the WSS Web Application:

1. Restore the WSS Web Application Database using the SQL iDataAgent to Recover SQL Server Databases. [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.

Restore a SharePoint 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.
• 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 and re-associate Web Application back to it if necessary. Delete Shared Services Provider for temporal usage.

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 to Recover SQL Server Databases. 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 and re-associate Web Application back to it if necessary. Delete Shared Services Provider for temporal usage.

Restore a SharePoint Server 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 to Recover SQL Server Databases. 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.

SharePoint Server 2003 Procedures

Restore a SharePoint Server 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 Recover SQL Server Databases. 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 SharePoint Server 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 to Recover SQL Server Databases. 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 SharePoint Server 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 SharePoint Server 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 to Restore Data - Microsoft SQL Server. 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 SharePoint Server 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.