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:
- SQL Server Fundamentals (SQL Database for Beginners)
- SQL Server 2019: What’s New
- How to Import and Export Data in SQL Server
- Essential SQL Server Administration Tips
- Introduction to Azure SQL Database
- Introduction to Data Science and SQL Server Machine Learning
- What’s New in Microsoft SQL Server Management Studio v17.4
- Essential SQL Sever Administration Tips
- How to Patch a Standalone SQL Server Instance
- The SQL Server Browser Service and UDP Port 1434
- The Maximum Number of Concurrent Connections Setting in SQL Server
- Top 10 SQL Server DBA Daily Tasks List
- There is no SQL Server Failover Cluster Available to Join
- Encrypting a SQL Server Database Backup
Rate this article:
Reference: SQLNetHub.com (https://www.sqlnethub.com)
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).