SQL Server databases are not supported on compressed volumes

re: SQL Server databases are not supported on compressed volumes

Martin Ritchie — Tue, 03 Oct 2006 23:53:00 GMT

What about putting SQL Server in a Microsoft Virtual PC Dynamically Expanding drive. Are those drives considered compressed or should this be ok.

re: SQL Server databases are not supported on compressed volumes

Hendrik — Fri, 26 Jan 2007 23:23:11 GMT

W O R K I N G Solution

----------------------------

1. Go to a command prompt

2. Navigate to the folder (here 'E:\') the file (here 'E:\Compressed_DB.mdf') is situated in

3. Type 'compact /u' and press enter

re: SQL Server databases are not supported on compressed volumes

Hema — Fri, 14 Sep 2007 20:49:58 GMT

W O R K I N G Solution

----------------------------

1. Go to a command prompt

2. Navigate to the folder (here 'E:\') the file (here 'E:\Compressed_DB.mdf') is situated in

3. Type 'compact /u' and press enter

re: SQL Server databases are not supported on compressed volumes

Neil b — Fri, 27 Mar 2009 14:43:02 GMT

thanks for this worked a atreat, did have to change my dat and log directory to d:somthing rather then just d but thanks :)

re: SQL Server databases are not supported on compressed volumes

firozozman — Fri, 19 Jun 2009 03:38:02 GMT

Thanks buddy.... it saved my time ;)

re: SQL Server databases are not supported on compressed volumes

Pankaj Kumar — Wed, 01 Jul 2009 02:04:12 GMT

from the windows explorer make sure the folder in which the .mdf file is being created, is marked as ReadOnly and uncheck the Compress contents check box.

The above error will go.