[Optimum] Unable to create or restore database "The file "C:\Program Files\xxxx.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed"

Created by Cheng Kah Poh, Modified on Wed, 11 Nov, 2020 at 9:34 AM by Cheng Kah Poh

The error message:

Solution:

Refer below picture, go to the SQL data folder(eg.C:\Program Files\Microsoft SQL Server\MSSQL10_50.QNEBSS\MSSQL\DATA) properties, under General>Advanced, untick "Compress contents to save disk space", OK. Then user can try to create or restore database.