Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I was adding a project collection to TFS it crashed mid way. It did not create the database for the collection. The collection shows in the TFS Admin Console, but it won't let me detach it because it says

TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.

How do i get rid of this ghost collection?

share|improve this question
add comment

3 Answers

Try repairing the db

dbcc checkdb ('TfsVersionControl',repair)

as found on: http://dotnet.dzone.com/news/database-corruption-tfs-2005?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Fcss+%28CSS+Zone%29

share|improve this answer
    
CHECKDB found 0 allocation errors and 0 consistency errors in database. –  James Helms Nov 4 '10 at 19:52
add comment

The best option is to delete the collection using below command.

syntax:TFSConfig Collection /delete /collectionName:[COLLECTION NAME]
TFSConfig Collection /delete /collectionName:Project( here project is name of the collection)

For example:

C:\Users> cd..

C:\> cd Program Files\Microsoft Team Foundation Server 2010\Tools

C:\Program Files\Microsoft Team Foundation Server 2010\Tools> TFSConfig Collection /delete /collectionName:Project
Logging sent to file C:\ProgramData\Microsoft\Team Foundation\Server Configuration\Logs\CFG_TPC_AT_0710_134506.log
Command: collection
TfsConfig - Team Foundation Server Configuration Tool
Copyright (c) Microsoft Corporation. All rights reserved.
Deleting a Team Project Collection is an irreversible operation. A deleted collection can not be reattached to the same or another Team Foundation Server. Are you sure you want to delete 'Project'? (Yes/No) y
Found Collection 'Project'. Deleting...
The delete of collection 'Project' succeeded.
share|improve this answer
add comment

This worked for me...

 1. Actions to perform on TFS 2010
   1.1 Using the TFS console "Detach" the collection from the "TFS server"

   1.2 Using the SQl Manager "Detach" the database for the corresponding TFS 
       collection



 2.  Actions to perform on TFS 2012
   2.1 Using the SQl Manager "attach" the database for the corresponding TFS 
       collection

   2.2 Make sure to give the TFS user account/s access to the database otherwise 
       the TFS server will not be able to access it.

   2.3 Using the TFS console "attach" the collection to the "TFS server"
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.