-
Title
Error: 'The file %\database_data.mdf is compressed but does not reside in a read-only database or -
Description
Error:
Msg 62301, Level 18, State 1, Line 0
SQL Server has returned a failure message to LiteSpeed for SQL Server which has prevented the operation from succeeding.The following message is not a LiteSpeed for SQL Server message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Northwind_Log.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Northwind_Data.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. -
Cause
The drive where the data and/or log file reside is compressed.
-
Resolution
WORKAROUND:
Access the drive via Explorer, right-click on the drive, Properties, uncheck 'Compress drive to save disk space'. Restart restore process.