Sunday, 19 May 2019

How to Re-solve “There is not enough space on the disk” Query error?

How to Re-solve “There is not enough space on the disk” Query error?


One of my friends communicated to me “Whenever I queried in SQL Server Management Studio, I keep on getting this error. How do I solve this?”

An error occurred while executing batch\Big query. Error message is: There is not enough space on the disk.

There can be two reasons
1 There is no space in the Drive where SQL Server files are stored
2 The drive where Tempdb is stored may not have enough space

But these are not issues to my friend as the Drive in which SQL Server files (Both mdf and ldf) and TempDB are in E drive which has enough space (200 GB+ free space).

It should be noted that whenever Queries are executed in SSMS that need result to be returned, SSMS caches the resulsets in a C drive under the Users Folder. So I asked my friend to check this folder

Tools–>Options–>Query Results–>SQL Server


It was found that it was pointing to C Drive and the drive does not have any free space at all. I asked him to change this path into different drive or clear some space on C drive by deleting any unwanted files and the problem is solved.

No comments:

Post a Comment

Disable CDC at table level

 How to Disable CDC( Change Data Capture) for tables Change Data Capture (cdc) property is disabled as default.  here I will Query you how t...