Restore SSPs (Office SharePoint Server 2007)

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2010-08-17

Before you perform these procedures, ensure that:.

• You are logged on to the server running the SharePoint Central Administration Web site.

• You have read Back up and restore SSPs (Office SharePoint Server 2007).

• You have created a backup folder on the network in which to store your backups. For more information, see Prepare to back up and restore a farm (Office SharePoint Server 2007).

Restore SSPs by using built-in tools

A Shared Services Provider (SSP) can include one or more content databases, configuration settings, and other data, including the search database and index. When you restore the SSP, you are restoring all of this data.

If your farm has more than one SSP, you must restore each SSP individually. If you restore the entire farm, all SSPs will be restored.

Important

Office SharePoint Server 2007 supports the use of multiple filegroups for the SSP search database. However, backup and restore in Office SharePoint Server 2007 are not filegroup-aware. There is no way to indicate where the new filegroup should be restored to. The restore process tries to put the crawl filegroup on the same drive where it existed when you made the backup. To restore, you must have drives for the crawl and primary filegroups that have the same drive letter as the initial backup drive.

Important

Membership in the Farm Administrators SharePoint group is the minimum required to complete the following procedure. You also need to be a member of the dbcreator fixed server role on the database server where each database is stored. The SSP content databases might be on a different database server than the SSP database.

Restore an SSP by using the user interface

1. On the SharePoint Central Administration Web site, on the Operations page, in the Backup and Restore section, click Restore from Backup.

2. On the Select Backup Location page, in the Backup File Location section, enter the universal naming convention (UNC) path to the backup folder.

3. On the Select Backup Package to Restore page, select the backup file you want to use to restore, and then click Continue Restore Process.

4. On the Select Component to Restore page, select the SSP you want to restore and then click Continue Restore Process.

5. On the Select Restore Options page:

   1. In the Restore Component section, verify that the SSP you selected is displayed.

   2. In the Restore Options section, select New configuration, and then click OK.

   3. In the New Names section, type new names and URLs for each component, or accept the default values.

6. Click OK.

Use the following procedure to restore a database by using the Stsadm command-line tool.

Important

Membership in the Administrators group on the local computer is the minimum required to complete the following procedure. You also need to be a member of the db_backupoperator fixed database role on each database you are backing up on the database server where each database is stored. The SSP content databases might be on a different database server than the SSP database.

Restore an SSP by using the command line

1. On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.

2. To obtain the backup GUID for the specific backup that you want to restore, type the following command, and then press ENTER:

   stsadm -o backuphistory -directory <UNC path>

   where UNC path is the path to the shared folder that contains the backup.

3. If you do not already know the name of the SSP you want to restore, type the following command, and then press ENTER:

   stsadm –o restore –showtree -directory <UNC path> -backupid <GUID from backuphistory>

   where UNC path is the path to the shared folder that contains the backup and where GUID from backuphistory is the GUID of the backup package that you want to restore.

   Note

   Items enclosed by square brackets ([ ]) cannot be restored.

4. To restore an SSP, type the following command and then press ENTER:

   stsadm -o restore -directory <UNC path> -backupid <GUID from backuphistory> -item <created path from tree> -restoremethod overwrite

   where UNC path is the UNC path to the backup shared folder, GUID from backuphistory is the GUID for the specific backup package that you want to restore, and created path from tree is the full farm path notation as displayed by the -showtree parameter.

5. When you receive a warning that all selected items will be overwritten, type y and then press ENTER.

6. When prompted, type the user name and password for the SSP content databases.

7. If the recovery completes successfully, the Command Prompt window displays the following text:

   Completed with 0 warnings.
   Completed with 0 errors.
   Restore completed successfully.
   ---------------------------------------------------------
   Operation completed successfully.
   

8. If the recovery does not complete successfully, the following message appears:

   The restore job failed. For more information, see the error log that is located in the backup directory. 
   

   The referenced error log is included in the sprestore.log file in the backup shared folder.

See Also

Concepts

Back up and restore SSPs (Office SharePoint Server 2007)
Back up SSPs (Office SharePoint Server 2007)