DotNet Mirror
  DNM facebook   DNM Google+   DNM Twitter   

The file "AdventureWorksDW2012_Data.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

By Ashok Nalam on 25 Nov 2013 | Category: SQL Server | Tagged: SQL Server error database 
  Discuss Add Comment   |  
Add rating Rate this resource   
Sometimes when you try to restore database from MDF file you might get an issue like
"The file "F:\AdventureWorksDW2012\AdventureWorksDW2012_Data.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."

The error is due to your MDF file is set to compressed mode, to resolve this issue please do the following steps below:
  1. Navigate to MDF file location
  2. Right click AdventureWorksDW2012_Data.mdf
  3. Right Click "Properties” > 
  4. Click “Advanced...”
  5. Uncheck “Compress contents to save disk space”
  6. OK
Advanced Properties of MDF file
Fig: Advanced Properties of MDF file

Hope it resolved your issue!
  Discuss Add Comment    
Add rating Rate this resource   
About the Contributor
Member Since : 10 Dec 2012
Member Points (Level) : 8666  (Professional)
Location : INDIA
Home Page : http://dotnetmirror.com
About : I am admin of this site.
Rate this resource
 
Add your Comment
Name Email WebSite
Captcha Refresh


Comments (0)
No comments found, click here to add comment.