Monday, October 23, 2006

Restore Team Foundation Server (TFS 2005) Database

Have you noticed the disparity about backup procedures documentation and how much information one can find about restoring from those backups?

What I am going to provide here is not new information: I just hope that this post will come up in some searches, therefore sparing some frustration.

Recently we had a bad day with our TFS database server, we decided to cut or losses and restore to the previous day's backups. Little we knew...

You will find comprehensive instructions on how to restore (http://msdn2.microsoft.com/en-us/library/ms252458.aspx or http://blogs.msdn.com/vstsue/articles/511396.aspx), you will diligently perform all the steps, fire up the servers, connect using Visual Studio and everything will seem to work properly. Until a week later when all of a sudden you will open a project you didn't touch for a while and when checking out an aspx page you'll see that it contains XML code. Or you'll find C# code belonging to another project into a DataSet XSD.

What happened? This happened: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251122&SiteID=1.

Yes, there is a cache in the TFS Application server, and restoring the databases without manually deleting the cache ("%Program Files%\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\VersionControl\Data") leads to bad, bad things.

No comments: