Archive for SQL

Checking space used in SQL Server

To check the space used in SQL Server, the following SQL is super-handy:

Hope that you will find it useful!

Error 5118 in SQL Server

This error occurs if you have compressed your hard drive, or created a database on a compressed drive. This results in Error 5118 in SQL Server.

 

To resolve the error, stop all SQL Server services from Control Panel -> Administrative Tools -> Computer Management -> Services and Application -> SQL Server Configuration – SQL Server Services

 

Close All Services, taking note which are active so that you can restart them after the process is complete

 

From the same window, go to services and stop the service SQL Server VSS Writer.

 

Uncompress the SQL Server installation folder

Restart the services you have turned off.

 

You’re done! The service is up again. Hope you’ll find this info useful!