Be careful setting up disc for SQL Server

Been going through different setup for SQL server setup.  One problem I ran into was that I ran into this error "{FileName}.mdf is Compressed But Does not Reside in a Read-only Database or Filegroup. The File Must be Decompressed".

First Bing search result put me through to a path trying to alter the backup file, but that didn't work.  After reading this one (http://blogs.msdn.com/b/sanchan/archive/2006/06/04/617585.aspxhttp://blogs.msdn.com/b/sanchan/archive/2006/06/04/617585.aspx), I was able to fix it by re-format the partition to turn off "Enable file and folder compression".  Unfortunately, I do feel that this feature is built to cater to 99% of customers, but killing the need for the very few.  I'll try to see if there is a way around it.

Print | posted on Monday, March 18, 2013 3:21 PM

Feedback

No comments posted yet.

Your comment:





 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski