Hi.
I'm using SQL Server 2005 beta 2 April CTP:
I am always getting this error while trying to attach a database and even when I try to create a file in a filegroup for table partitioning.
Error:
The file "<filename> " is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
is it a security problem?
Thanks
Christina
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
folder.
|||I saw the same thing but is that the expected behavior. Can we not create database with database files any where on the hard drive.|||
I am not aware of such requirement, but based on your error message
I think your file is compressed (or is placed on compressed disk or folder)
Could you please check it. Click on the file property and go to Advance attributes to see if
"Compress contents to save disk space" is activated (checked).
Do the same for the file folder. If this is the case, please deactivate it.
SQL Server supports compressions with some limitations
(see Using NTFS Compression with Read-Only Secondary Filegroups and Read-Only Databases under Read-only filegroups in BOL)
Thanks
Mirek
Did you have a chance the check if your file is using compressed media?
Thanks
Mirek|||Dear Mirek,
Thanks for your input.
I just tried it and as u said, it worked.
Regards,
Christina
No comments:
Post a Comment