







Restoressp: Stsadm operation (Office SharePoint Server) | |
![]() ![]() |
Stsadm command-line tool (Office SharePoint Server) > Stsadm operations (Office SharePoint Server) > Shared Services Provider: Stsadm operations (Office SharePoint Server) > |
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.
Operation name: Restoressp
Description
Creates a Shared Service Provider using a restored database or restored databases.
![]() |
---|
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.
|
||
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.
|
||
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.
|
||
searchsqlauthpassword |
A valid SQL password that is used in conjunction with the searchsqlauthlogin parameter |
No |
Microsoft SQL Server credentials to the search database.
|
||
ssl |
<none> |
No |
Use Secure Sockets Layer (SSL) for Web services.
|