Could not allocate a new page for database ‘TEMPDB’ because of insufficient disk space in filegroup ‘DEFAULT’. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup

The error happens when your disk space is full on TempDB.Check the space on the Drive where the TempDb is located .

Solutions

a.Review the Query and check if it can be better optimised. Some of the Queries’ intermediate heavy datasets are stored in tempdb before returning the results.
b.The most easiest way I found is to restart the SQL Server service. Every Time the SQL server is restarted the tempdb gets flushed thereby reducing all the disk space.


Posted June 18, 2009 by Vivek. Comments and trackbacks are open. Follow the comments feed.
Filed under:
Tagged with: .

Leave a Reply

←
→