Link to home
Start Free TrialLog in
Avatar of Swindle
SwindleFlag for United States of America

asked on

There is not enough space on the disk. (exception from HResult: 0x80070070) (mscorlib)

I have a single user that is getting this error when trying to run a select statement from SQL Server Management Studio.  There is tons of free disk space on all drives on the server.  The log files are set to autogrow by 10% and have tons of room to grow (more than 100GB).  The select statement only returns 140,000 rows, so it isn't even that big.  I was not able to reproduce the problem, nor was another user that tried it....  We were both able to run the query without any issues.  I am at a total loss.  Anyone have any suggestions or something I'm overlooking?
ASKER CERTIFIED SOLUTION
Avatar of MohammedU
MohammedU
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Swindle

ASKER

Thanks M,  that's what I was leaning towards too.  I just found out that they are using a remote desktop connection and opening SSMS from some other machine.  I am waiting for them to respond with which machine they are actually connecting to SQL Server from and I will check those things.
Some of these errors are very misleading...
I have seen similar type of errors when you run out of memory on the clients..
Avatar of Swindle

ASKER

The machine they had remoted into for using SSMS was out of disk space.  
Avatar of abhijit_k
abhijit_k

check the disk quota for the user.