RegisterDB Command
Use RegisterDB to update name of the server that hosts the configuration database in Visual Studio Team Foundation Server. You might use this command when restoring the configuration database to new hardware or when changing the domain of a deployment.
Important
For the RegisterDB command to succeed, the following application pools and programs must be running:
Team Foundation Server Application Pool (application pool)
ReportServer (application pool)
SQL Server Reporting Services (program)
In addition, the following components must not be open or running:
Required Permissions
To use the RegisterDB command, you must be a member of the Team Foundation Administrators group on the application-tier server for Team Foundation and a member of the sysadmin group in SQL Server on the data-tier server for Team Foundation. For more information, see Team Foundation Server Permissions.
Note
Even if you are logged on with administrative credentials, you must open an elevated Command Prompt to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt, click Start, right-click Command Prompt, and click Run as Administrator. For more information, see the Microsoft Web site.
TFSConfig RegisterDB /SQLInstance:ServerName
Parameters
Placeholder |
Description |
|---|---|
ServerName |
Specifies the name of the server that hosts the configuration database for Team Foundation Server and the name of the instance if you want to use an instance other than the default instance. If you specify an instance, you must use the following format: ServerName\InstanceName |
Argument |
Description |
|---|---|
/SQLInstance:ServerName |
Required. Specifies the name of the server that is running SQL Server and the name of the instance if you want to use an instance other than the default instance. If you specify an instance, you must use the following format: ServerName\InstanceName |
Remarks
Important
Back up the databases for Team Foundation Server before you use this command.
You must provide the exact name or address of the configuration database for this command to operate correctly. If you must change the server on which this database is stored, you must ensure that Team Foundation Server points to the new location.
Example
The following example redirects Team Foundation Server to a configuration database that is located on the server ContosoMain in the SQL Server instance TeamDatabases.
Note
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.
TFSConfig RegisterDB /SQLInstance:ContosoMain\TeamDatabases
See Also
Other Resources
Managing Server Configuration with TFSConfig