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.
Learn more tips like this – Enroll to our Online Course!
Check our online course titled “Essential SQL Server Administration Tips” (special limited-time discount included in link).
Learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!
Skill Up with our High-Quality Online Courses!
- Boost SQL Server Database Performance with In-Memory OLTP
- Essential SQL Server Administration Tips
- SQL Server Fundamentals (SQL Database for Beginners)
- Essential SQL Server Development Tips for SQL Developers
- The Philosophy and Fundamentals of Computer Programming
- .NET Programming for Beginners: Windows Forms (C#)
- Introduction to Data Science and SQL Server Machine Learning
- Introduction to Azure SQL Database
- SQL Server 2019: What’s New
- Entity Framework: Getting Started (Complete Beginners Guide)
- How to Import and Export Data in SQL Server
- Get Started with SQL Server in 30 Minutes
- A Guide on How to Start and Monetize a Successful Blog
- 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).