Download StarTeam Server Help - Borland Technical Publications

3
Use the Cross-Platform Client to connect to Server 1 and delete Project C.
4
Shut down the Server 1 configuration.
5
Run Purge on the Server 1 configuration to physically remove the deleted data.
6
Use the Vault Verify utility to verify the integrity of the configuration data.
7
If necessary, make full database and Vault backups of the Server 1 configuration.
8
Restore the database and Vault backups of the Server 1 configuration from step 1 on Server 2.
9
If using a different Vault location, configure the files hive-index.xml and starteam-serverconfigs.xml to point to the new location.
To remap the SQL Server logins for the Server 2 configuration
1
Connect to the database using sa or windows authentication and change the database context to the restored
database.
2
Run command sp_change_users_login 'REPORT'. This command will print the orphaned user name.
Note:
3
The following steps assume that the orphaned user is starteam. Use the appropriate
orphaned user as reported by the command sp_change_users_login 'REPORT'.
Run the following commands in SQL Query Analyzer.
♦ sp_addlogin starteam
♦ EXEC sp_change_users_login 'Update_One', 'starteam', 'starteam'
4
Copy the contents of the script set-owner-to-dbo.sql and run it against the database.
Note:
5
As sa user, execute the script by running the command exec change_db_ownership 'starteam'.
Note:
6
This script can be found in the DBScripts folder under the StarTeam Server installation
location.
Warnings generated from this command are safe to ignore.
Go to SQL Enterprise Manager or SQL Server Management Studio for SQL Server 2005 and delete user
starteam from the database. Select Yes to also delete the schema.
Note:
This action deletes the database user starteam, not the SQL Server Login starteam.
Deleting the schema deletes all the database objects owned by this database user, which
is required in order to delete a database user. This step is essential because, while there
can be many users with dbo privileges, there can be only one database owner. StarTeam
Server must be run by the database owner.
7
Run the command sp_changedbowner starteam.
8
Log into the database as user starteam (the password is blank by default) and run the SQL statement select
* from s0.
9
Ensure that one row is returned.
223