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 (TFS) 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 TFS 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.
The following example shows how to try to repair he databases for a deployment of Team Foundation Server.
The examples are for illustration only and are fictitious. No real association is intended or 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.