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. |