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