I encountered problems like the one ever posted here and in the forum SQL Server Tools.
In one case, the user solved the problem by turning dynamic disk into static (basic) disks.
In another case, the soution was not known.
Here is the message I encountered.
Msg 5118, Level 16, State 1, Line 1
The file "E:\Database\Microsoft\Usage.mdf" is compressed but does
not reside in a read-only database or filegroup. The file must be
The problem is : my disk is static (basic), and not compressed. How can this happen?
I also have Oracle installed. Oracle instance is able to process files in the disk E.
Again, the disk E is not compressed since the beginning of its creation, neither is disk D.
If I moved the data files and transaction log files to disk D, I'm able to attach the database.
How can this be?
View Complete Post