Database Attach Shared Services Provider (SSP)
Performing a database attach using STSADM.exe is useful for migrating or upgrading existing data. Here is an example of how to use the STSADM.exe commands to be able to perform a db attach for the Shared Services Provider (SSP):
Create the web application and associate the Shared Services Content database with the restored database by first creating a web application for the Shared Services Provider and specifying the content database that was restored.
For example:
stsadm.exe -o extendvs -url http://intranet:8080 -ownerlogin redmond\user -owneremail
a@b.com -exclusivelyusentlm -databaseserver SQLServer -databasename SharedServices1_Content -apcreatenew -apidname SSP_Apppool -apidtype configurableid -apidlogin redmond\user -apidpwd MyPassword
Note that the databasename parameter is the Shared Services Content database that was restored.
To create the SSP we use the restoressp command with the sspdatabasename and searchdatabasename parameters set as the databases that were restored.
For example:
STSADM.EXE -o restoressp -title Migrated_SSP -url http://intranet:8080 -ssplogin redmond\user -ssppassword MyPassword -mysiteurl http://intranet/MySite -indexserver intranet -indexlocation "D:\Program Files\Microsoft Office Servers\12.0\Data\Applications" -sspdatabaseserver intranet -sspdatabasename SharedServices1 -searchdatabaseserver intranet -searchdatabasename SharedServices1_Search
Again note that the sspdatabasename and searchdatabasename parameters are the databases that were restored as these will now be attached to the Shared Services Provider for the installation.
