Restoressp: Stsadm operation (Office SharePoint Server)

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: 2015-03-09

Operation name: Restoressp

Description

Creates a Shared Service Provider using a restored database or restored databases.

Note

The restoressp operation only applies to Microsoft Office SharePoint Server 2007 and Microsoft Office SharePoint Server 2007 for Search. It does not apply to Microsoft Office Project Standard 2007 or Microsoft Office Forms Server 2007 as an SSP can be created without specifying an index server.

Syntax

stsadm -o restoressp

**   -title <SSP name>**

**   -url <Web application URL>**

**   -ssplogin <user name>**

**   -mysiteurl <MySite URL>**

**   -indexserver <index server>**

**   -indexlocation <index file path>**

**   -[keepindex]**

**   -sspdatabaseserver <SSP database server>**

**   -sspdatabasename <SSP database name>**

**\[-ssppassword \<password\>\]**

**\[-sspsqlauthlogin \<SQL user name\>\]**

**\[-sspsqlauthpassword \<SQL password\>\]**

**\[-searchdatabaseserver \<search database server\>\]**

**\[-searchdatabasename \<search database name\>\]**

**\[-searchsqlauthlogin \<SQL user name\>\]**

**\[-searchsqlauthpassword \<SQL password\>\]**

**\[-ssl {yes | no}\]**

Parameters

Parameter name	Value	Required?	Description
title	A valid title, such as "SSPName1"	Yes	The name of the Shared Services Provider (SSP) to create. The name must be unique.
url	A valid URL, such as http://server_name	Yes	The URL of the Web application that hosts the Shared Services Provider Administration site.
ssplogin	A valid login credential in the form domain\username	Yes	The account under which the SSP timer job and Web services run.
mysiteurl	A valid URL, such as http://server_name	Yes	A Web application is required for My Sites. This Web application is used to host personal sites and profile pages. It is recommended that a different Web application is used than the one used for the Shared Services Provider Administration site, so that you can back up and restore My Sites independently of the SSP. Only applies to Office SharePoint Server 2007.
indexserver	A valid server name, such as "Index1"	Yes	Specifies the index server that crawls content in all Web applications associated with the SSP. Note The specified server must have the Office SharePoint Server Search service running.
indexlocation	A valid folder location in the form "C:\Folder\Subfolder"	Yes	Configures the search server that has the location of where the index resides. This parameter is used in conjunction with the osearch operation. For additional information, see Osearch: Stsadm operation (Office SharePoint Server).
keepindex	<none>	No	Does not reset the search index after a SSP is restored. Note The keepindex parameter should be used only if the search index and databases were restored at exactly the same time using a third-party backup and restore application.
ssppassword	A valid Windows password	No	Password for the account. This parameter is not required if the account has no password (for example, "NetworkService").
sspdatabaseserver	A valid database server, such as "Test" or "Test\Instance"	Yes	The database server that will store SSP-specific configuration data. The database server can also include instance names (for example, server\instance).
sspdatabasename	A valid database name, such as "DBN"	Yes	The database server name that will store SSP-specific configuration data.
sspsqlauthlogin	A valid SQL account	No	Specifies SQL login credential information. This parameter only applies if SQL authentication is used. By default, Windows integrated authentication is used.
sspsqlauthpassword	A valid SQL password	No	Specifies SQL password to the SSP database. This parameter only applies if SQL authentication is used. By default, Windows integrated authentication is used.
searchdatabaseserver	A valid database server, such as "DS1" or "DS1\Instance"	No	Specifies where the search database will be created on the computer running SQL Server. The database server can also include instance names (for example, server\instance).
searchdatabasename	A valid database server, such as "DB1"	No	Specifies a database name for the search database that will contain crawled properties and their values.
searchsqlauthlogin	A valid SQL login account	No	Microsoft SQL Server credentials to the search database. Note This parameter only applies if SQL authentication is used. By default, Windows integrated authentication is used.
searchsqlauthpassword	A valid SQL password that is used in conjunction with the searchsqlauthlogin parameter	No	Microsoft SQL Server credentials to the search database. Note This parameter only applies if SQL authentication is used. By default, Windows integrated authentication is used.
ssl	<none>	No	Use Secure Sockets Layer (SSL) for Web services. Note If you choose to enable SSL for Web services, you must add the certificate on each server in the farm by using the IIS administration tool. Until this is done, the Web services are not available.