I have dev environment with SQL and Sharepoint 2013 installed on same machine. My C drive was full so i moved "WSS Logging" data base to another drive. After movement none of my site collections are working apart from Central Admin.
I can not even create a new web application ans it throws following error:
The file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
EDIT I used below mentioned URL to move DB. https://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files
Waqas's solution below worked for New application but i still can not access the existing site collection. I am getting below error:
HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid