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.

I have a Windows 2008 R2 virtual machine running Team Foundation Server 2013 and MS SQL Server Express. We are a small (<10 programmers) development shop and have 3-4 collections in TFS. We stood this system up 1.5 months ago. Today TFS stopped working with the error:

TF30042: The database is full. Contact your Team Foundation Server administrator.

Sure enough, upon investigation of the SQL tables that underpin TFS. I found one that had grown to over 10 GB, which is the limit for SQL Express. Investigation of the error logs on the server confirms:

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size     would exceed your licensed limit of 10240 MB per database.

The obvious solution is to move to SQL Server 2008, which we are doing. However, I wanted to know if it is normal for TFS to create tables like this? 10 GB in six weeks? Does anyone know how to clean or manage what goes into the SQL tables underlying TFS? Any help is much appreciated.

EDIT

We are doing a small automated build and a few automated test runs on a continuous basis whenever someone checks in. I have read at http://blogs.msdn.com/b/bharry/archive/2011/10/31/tfs-databases-growing-out-of-control.aspx that this can cause large SQL tables. Does anyone know how to delete the unneeded data from this operation?

share|improve this question
    
What's the size of the Tables? stackoverflow.com/questions/7892334/… –  MichelZ Apr 16 at 18:03
    
We have been using TFS for a small team for years now, and we're at ~6 GB Database size, so there seems to be something wrong, unless your uploading tons of sourcecode or attachments of course –  MichelZ Apr 16 at 18:13
    
MichelZ - size of the table is just over 10300 KB. –  JHowIX Apr 16 at 18:25
    
Size of all tables?? –  MichelZ Apr 16 at 18:26
    
There is one particularly table called dbo.tbl_Content that is just over 10 GB. I would post a picture but SF won't let me until I have some rep. –  JHowIX Apr 16 at 19:11

1 Answer 1

up vote 0 down vote accepted

According to: https://mgrowan.wordpress.com/2014/04/02/need-help-tfs-tbl_content-table-and-database-growth-out-of-control/

Update 4 April 2014: Something has happened overnight. I’m assuming the workspace clean has caused it. We now have 115 GB space available! What’s odd though is that the tbl_Content size has dropped that space. What does that table have to do with workspaces? Some insights into how this is working so we can manage our systems would be appreciated.

So, try to clean your Workspaces. The automatic build might leave some of them. You can use the free TFS Sidekicks to do this.

share|improve this answer
    
Do we know if this works with TFS 2013? I think their website is currently down but their download link (visualstudiogallery.msdn.microsoft.com/…) advertises only up to TFS2008 –  JHowIX Apr 17 at 14:00
    
I'm using them with TFS 2013, so yes. But there's a version specific to TFS 2013 –  MichelZ Apr 17 at 14:58

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.