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.