CODEWITHSUNDEEP
tfs
Amitabha
Amitabha

Reputation: 1733

TF30042: The database is full

Today team reports an error of TFS 2012:

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

Event Log from data base server:

MSSQLSERVER: Could not allocate space for object 'dbo.tbl_NotificationQueue'.'PK_tbl_NotificationQueue' in database 'Tfs_Real-Time collection' 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.

MSSQLServerOLAPService: An error occurred while writing a trace event to the file, \?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log\FlightRecorderCurrent.trc.

The C driver is no space available to use.

Could anyone give some suggestions?

Upvotes: 11

Views: 25325

Answers (2)

Tzuionet
Tzuionet

Reputation: 1

In my case the table "tbl_JobHistory" had become much too large (>7.5GB). As a result, the 10GB of the SQL-Express database were fully utilized. With Microsoft SQL Server Management Studio you can easily view the largest tables: "Reports" > "Standard Reports" > "Disk Usage by Top Tables". I deleted the data in "tbl_JobHistory" and then shrinked the database.

Screenshot

Upvotes: 0

Andrew Clear
Andrew Clear

Reputation: 8030

Option 1: Clean the drive to free up space. Delete transaction logs, look for extraneous test case attachments, build drops checked into source that sort of thing.

Option 2: Get a bigger hard drive.

Upvotes: 14

Related Questions