Detach a TFS Project Collection when the database doesn't exist

Question

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?

Answer 1

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