Home / server / Questions / 334192
Accepted
Brian Deragon
Asked: 2011-11-23 10:24:41 +0800 CST

TFS Check-In Exception - TF30042 Database is Full

  • 772

I'm trying to check a rather large file into Team Foundation Server (TFS) and getting the following exception.

TF30042: Database is Full. Contact your Team Foundation Server administrator.

Problem is, I am the administrator. I've checked the database files (both collection and tempdb), and I'm nowhere near the limits in SQL Server 2008 R2, and I've set AutoGrowth to use 8gb chunks and unlimited size on both the database and log files. We have plenty of disk space on the drive that the SQL Server database resides on, and I don't see any size limits in the TFS Administration Console.

From everything I can tell, it seems that I should be fine, what am I missing?

team-foundation-server sql-server-2008 version-control visual-studio-2010

3 Answers

  1. There's another possibility answer for why this error might occur (in the general case), you could be running Express Edition, and your TFS database has reached the maximum database size for the license.

    • 1

  2. There are four possibilities for this failure:

    1. TempDB Log file is not large enough
    2. TempDB Data file is not large enough
    3. Your CollectionDB log file is not large enough
    4. Your collectionDB data file is not large enough

    If you go into SQL Management Studio and look at 'Properties' of TempDB (under 'System Databases'), then 'Storage' - what is the size and autogrow parameters set to for both Log and Data?

    Then do the same for your collection database. If the log file is not large enough to handle the contents of your large checkin, then SQL will return this error.

    • 0
  3. Best Answer

    Finally figured it out, Remote Query Timeout on our SQL Server instance was set to 90 seconds. Uploading almost 3 GB worth of information was causing the query to timeout.

    • 0