January 22, 2014 at 7:54 am
I ran a backup the other day (compressed it) on our QA server. I had to bring it down to my PC and am trying to restore it on my local instance. But I keep getting the message
The file "File.MDF" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
The drive I saved this file on is NOT compressed. I know this because I had this issue last month (different backup file, different DB) and decompressed my hard drive so I could restore it. I also verified the Properties today to make sure and the check box is empty. My drive is not compressed. This means the file is the problem. But how do I decompress a backup file without restoring it?
Any thought?
January 22, 2014 at 8:00 am
Ah. I think it didn't uncompress the subfolders. The root allows me to restore the database files there just fine.
So, nevermind. Thanks for reading.
January 22, 2014 at 8:22 am
I dislike disk compression for this reason.
Thanks for the update and glad you solved it. Out of curiosity, did you check properties on all subfolders or use some other method?
January 22, 2014 at 9:17 am
Steve Jones - SSC Editor (1/22/2014)
Did you check properties on all subfolders or use some other method?
The subfolder properties don't tell me if compression is on for them. I experimented with the restore by changing the database file paths from "D:\MyDataPath\" to "D:\" and the restore worked.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply