You can use the TFSConfig Repair command to attempt to repair connections to or problems with the databases in your deployment. When you use the Repair command, all services are stopped, Team Foundation Server is taken offline, and a repair operation is run on the configuration database. After that operation is completed, repair operations are queued for the collection databases, and Team Foundation Server is returned to an online state.
To use the Repair command, you must be a member of the Team Foundation Administrators security group on the application-tier server for Team Foundation. You must also be a member of the sysadmin security group on each server and instance of SQL Server that hosts a database for Team Foundation. For more information, see Team Foundation Server Permissions.
Even if you log on with administrative credentials, you must open an elevated Command Prompt window to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt window, click Start, right-click Command Prompt, and click Run as Administrator. For more information, see this page on the Microsoft Web site: User Account Control.
The following example shows how to try to repair he databases for a deployment of Team Foundation Server.
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 - Team Foundation Server Configuration Tool Copyright © Microsoft Corporation. All rights Reserved. Acquiring the servicing lock. Servicing lock acquired. Stopping application... Application stopped successfully. Starting application... Application started successfully.