First off, let me say that I'm fully aware that not backing up my databases was dumb.  I used to be a sysadmin before I got into software development so this is kind of like the equivalent of a doctor smoking 3 packs of cigarettes a day.  I should know better. 

That said, I had my TFS running in a virtual server on a USB hard drive and it dropped on the floor yesterday while TFS was running.  I've got bad blocks on the drive and it's pretty dead. 

The only TFS database I was able to retrieve was TfsVersionControl.  I've mounted it on another SQL Server and I can access it.  So, theoretically, I've got my files.  (I also was able to get the reporting services encryption key.)

Here's my question: Since a restore is out of the question, is there any way that I can just dump all the files out of TfsVersionControl?  Basically, do a get latest via stored procedure?  I don't need it to be in the right organized folder structure, just a straight-up dump of the latest version is all I need.

 -Ben

1. do a clean install of TFS
2. overwrite the TfsVersionControl database with your recovered copy
3. clear the app tier cache by deleting "%programfiles%\microsoft visual studio 2005 team foundation server\web services\versioncontrol\data"

Thanks Richard! It worked. (What a relief!)

The only diff from what you wrote was that I had to go into SQL Server and grant the TFSService user permissions on the restored TfsVersionControl database.

Thanks a ton,
-Ben