we've got a MSSQL database on Win2003 which resides in compressed folder. The backups were all successfull, but when we want to restore a database (under new name) to that folder, we got the following error:
Query Result [The file "D:\Microsoft SQL Server\TEST\IFLEX_2.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
The file "D:\Microsoft SQL Server\TEST\IFLEX_1_2.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
An exception occurred while executing a Transact-SQL statement or batch.].
When we repeat the restore to an uncompressed location on the same client, it works well.
Is there anything official handling MSSQL on compressed folders with Simpana (our version is 9SP11b).