TF30042: The database is full

Question

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?

Answer 1

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.