How to Resolve “Property SpaceAvailabable is not available for Database ‘[tempdb]'”

Under certain circumstances, when working in SQL Server Management Studio, you might get the error message “Property SpaceAvailabable is not available for Database ‘[tempdb]’“.

 

Why I got this message?

Most of the times, you might get the above message because something else happened prior to the action that triggered the error message.

For example, maybe the disk got full, or certain permissions might have been revoked, or there is blocking, etc.

The exact error message is the below:

TITLE: Microsoft SQL Server Management Studio
——————————

Cannot show requested dialog.

——————————
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

——————————

Property SpaceAvailabable is not available for Database ‘[tempdb]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights (Microsoft.SqlServer.Smo)

 

How to Resolve the Issue

There are certain actions you can take, towards resolving the issue. Since the root cause might be different in each case, there is a list of of suggested things you can check:

• Check that there is no issue with the disk used by TempDB data and log files (i.e. disk full, etc.)
• Confirm that there is no issue with the disk(s) used by the rest of the system databases (msdb, model, master)
• Verify that you have the necessary permissions on the SQL Server instance
• Check and resolve any blocking issues on the SQL Server instance
• Check the Windows Event Viewer for any issues related to SQL Server
• If you are connected to the SQL Server instance from a client PC, you can try accessing the instance locally from within the server

If nothing from the above resolves the issue, as a last resort, and after you get the required approvals and downtime from Management, you can try restarting the SQL Server instance, or in the case of a SQL Failover Cluster Instance, fail over to another node.

 

Learn more about SQL Server Administration – Enroll to the Course!

We recommend that you enroll to our online course Udemy 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!

Enroll Now with Discount!

 

 

Featured 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 with C#
• Introduction to Data Science and SQL Server Machine Learning
• Introduction to Azure SQL Database for Beginners
• SQL Server 2019: What’s New – New and Enhanced Features
• Entity Framework: Getting Started – Complete Beginners Guide
• How to Import and Export Data in SQL Server Databases
• Learn How to Install and Start Using SQL Server in 30 Mins
• A Guide on How to Start and Monetize a Successful Blog

 

Related SQL Server Administration Articles:

• How to Find the OS Version of your SQL Server Machine – Single vs Many Machines
• Essential SQL Sever Administration Tips
• There is not enough space on the disk. (mscorlib)
• 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
• …more

 

Rate this article: (1 votes, average: 5.00 out of 5)

Loading...

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

© SQLNetHub