Why Does TFS Allow Orphaned Content and How Do I Get Rid of It?

Posted by Chad on Stack Overflow See other posts from Stack Overflow or by Chad
Published on 2010-03-22T16:47:18Z Indexed on 2010/03/23 17:33 UTC
Read the original article Hit count: 157

Filed under:

tfs

My TfsVersionControl database has grown to 40+ GB in size. We recently did a TFS Destroy on a folder tree that should have cleared up at least 10 GB but instead it seemed to have no effect.

When I look at the tables in TfsVersionControl, I am first shocked to see that there are no foreign keys at all in the database. Running a few queries, I see that there is some orphaning going on:

tbl_Content has 13.9 GB of records that don't have a related tbl_File record
tbl_File and tbl_Content have 2.4 GB that don't have a related tbl_Namespace record

The cleanup job seems to be running nightly (prc_DeleteUnusedContent) and running it against the database manually doesn't remove any orphans. I see in the log for the cleanup job that it failed on 3/16, which is the morning after I destroyed the large amount of data. The error was due to a full transaction log.

Could that error be the reason I'm left with all this orphaned data that can't be deleted? How can I permanently destroy this unneeded content?

Related posts about tfs

TFS - Rebinding solution to new TFS when prior TFS no longer available

as seen on Stack Overflow - Search for 'Stack Overflow'
The prior instance of TFS I was using is no longer available and I have a test project I want to bind to the new instance of TFS. However, when I try to add the solution to source control, the error message tells me that the collection is not available on the server. I have deleted all old source… >>> More
TFS 2010 Basic Concepts

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Normal 0 false false false false EN-US X-NONE X-NONE … >>> More
TFS 2010, can I migrate source code only ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Our old TFS 2008 installation is getting old, and we would like to migrate to TFS 2010. However, the structure of our team projects is not so well thought out, and there has been various experiments with process templates and editing of work items and so on. Therefore, I would like to migrate our… >>> More
Insufficient Permissions Problems with MSDeploy and TFS Build 2010

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I ran into these problems on a TFS 2010 RC setup where I wanted to deploy a web site as part of the nightly build: C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\Web\Microsoft.Web.Publishing.targets (3481): Web deployment task failed.(An error occurred when reading the IIS Configuration… >>> More
TFS 2008 Web Access Report 100 record limitation

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
By default TFS 2008 Web Access has the limit of 100 record when you open any query in report mode. Even if you tried to export the query to excel or PDF you will only get first 100 record exported. To overcome this issue, you have to reconfigure this count in the web.config file Navigate to… >>> More

Developer IT

Why Does TFS Allow Orphaned Content and How Do I Get Rid of It? - Developer IT

Why Does TFS Allow Orphaned Content and How Do I Get Rid of It?

tfs

Related posts about tfs

TFS - Rebinding solution to new TFS when prior TFS no longer available

TFS 2010 Basic Concepts

TFS 2010, can I migrate source code only ?

Insufficient Permissions Problems with MSDeploy and TFS Build 2010

TFS 2008 Web Access Report 100 record limitation

Categories cloud