Nowadays storage is cheap (relatively
) and the problems of shortage of space are less frequent. But sometimes they do happen. And some of these times, someone could think enabling NTFS Folder Compression
is a good idea. Maybe it is, but just for one folder and not the whole drive. Especially drive C:.
Well, I have no idea why this ever happened. But Windows will allow you to do so on a folder with a live database (even
though it shouldn’t
) – at least it will do this if you compress the whole drive. And when you try to restore any database or create a new one on that drive, you will be greeted by this error:
Msg 5118, Level 16, State 3, Line 1
The file "C:\MSSQL\Your_File.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
To fix it simply disable NTFS compression on the folder used by SQL. Or disable it for the whole drive. Well, never use it in the first place! cya!
This entry was posted in SQLServer
and tagged Backup
, Compressed folders
. Bookmark the permalink