There is not enough space on the disk. (mscorlib)

In this short article, we will talk about how to resolve an error message you might get when running queries in SQL Server Management Studio (SSMS), and that is the error message: “There is not enough space on the disk. (mscorlib)“.

Since the above error message just gives an indication on what the issue is, below, I suggest a list of things you need to check and possibly handle if required. The suggested actions can help you resolve the issue.

 

Step 1 – Checks to Perform on your PC

The first thing you need to check when you get the “not enough space on the disk (mscorlib)” error message, when running queries in SSMS, is the system drive (usually the C drive) on the PC you are running SSMS.

You need to perform this check, because SSMS operation is affected, if the system drive of your Windows OS has a low disk space (i.e. it has only a few hundred MB of free disk space).

In such case, if you see that the free space on the system drive is low, you need to take the appropriate actions towards safely releasing more free space.

 

Step  2 – Checks to Perform on the Database Server

If Step 1 did not help (i.e. there are many GB of free space on your local PC’s system drive), you need to also check if there is adequate free space on the corresponding disk drives on the database server. To this end, you need to check the below drives on the database server:

  • System disk drive (usually C drive)
  • TempDB disk drive(s)
  • Data files disk drive(s)
  • Log files disk drive(s)

If any of the above disks needs more free space, you will need to add some.

 

Become a SQL Server Pro – Check our Curated List of Online Courses:

 

Related Articles:

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub