TFS repeatedly getting the TF30042 error

Question

HI,

In my TFS 2010 from last 3 days repeatedly  i getting "TF30042: The database is full. Contact your Team Foundation Server administrator." I am using Sql server 2008, i released the memory of temp. but still getting this error please help me.

Answer 1

Hi Madineni, 

Thanks for your post.

Please check the disk space which your SQL Server 2008 installed, ensure there has enough disk space for your SQL Server databases. 

And you can try change your TFS databases to the Simple recovery model, please refer to this blog: http://bhavikblogs.blogspot.com/2009/05/tf30042-database-is-full-contact-your.html.   

But, if there has enough disk space for your SQL Server databases, please ensure your TFS databases’ file auto growth set to Unrestricted File Growth. Please refer to this article: http://osnabrugge.wordpress.com/2011/09/05/solving-tf30042-the-database-is-full-contact-your-team-foundation-server-administrator/.  

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 2

HI John Qiao,

Thank for quick response,

I tried above two steps, but still i getting same error.

I changed the database "Tfs_DefaultCollection" from full to simple and i sink the database, and also in my SQL SERVER 2008 installed disk have 40GB free space.

Also i changed the "Tfs_DefaultCollection"  .mdf file to Unrestricted file Growth, it taken space 4,194,304KB last its not compressing and not going up. only .LDF if is compressing.

after trying these also i getting "TF30042: The database is full. Contact your Team Foundation Server administrator."

in SQL server log i seen this error

2012-06-13 14:52:16.72 spid66      Could not allocate space for object 'dbo.tbl_LocalVersion'.'PK_tbl_LocalVersion' in database 'Tfs_DefaultCollection' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Actually John i am using Sql Server 2008 Express Edition from this any issue...!

please John help me.

Thanks

Madineni

Answer 3

Looks like you hit the max database size for SQL Express 2008 (4GB).  You could upgrade your SQL Express instance to 2008R2 for a max database size of 10GB.

Answer 4

Better you upgrade to SQL Server 2008 R2 for better performance and to over come this issue.

Regards

Vasu Chowdary Kodidela

---

Vasuki Chowdary

Answer 5

Hi Madineni,

TFS ships with a dedicated-use license for SQL 2008 Standard.  Is there some reason you're not using that?  This would get you past this issue and you wouldn't have the 10G limit hanging over your head.

---

Ryan Hanisco, PMP, PMI-ACP, CISSP
MCSE, MCTS:TFS 2010, SQL 2005
RyanHanisco.com