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 on Udemy titled “Essential SQL Server Administration Tips” (special limited-time discount included in link).
Via the course, you will 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!
- AI Essentials: A Beginner’s Guide to Artificial Intelligence
- SQL Server 2022: What’s New – New and Enhanced Features
- Working with Python on Windows and SQL Server Databases
- Introduction to Azure Database for MySQL
- Boost SQL Server Database Performance with In-Memory OLTP
- Introduction to Azure SQL Database for Beginners
- Essential SQL Server Administration Tips
- SQL Server Fundamentals – SQL Database for Beginners
- Essential SQL Server Development Tips for SQL Developers
- Introduction to Computer Programming for Beginners
- .NET Programming for Beginners – Windows Forms with C#
- SQL Server 2019: What’s New – New and Enhanced Features
- Entity Framework: Getting Started – Complete Beginners Guide
- Data Management for Beginners – Main Principles
- 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 Database and Software Architect, Certified Database, Cloud and AI professional, Author, a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 20 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub. 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. Moreover, Artemakis teaches on Udemy, you can check his courses here.