Overview
Archives stores are not being created. The file ..\GFI\Store\Debuglogs\ManagementProviders.log shows the following information:
2013-05-07,11:22:00,624,1,"#00000B1C","#0000000B","error ","ManagementProviders","Error: (MSSql) CreateDatabase(). Error execute:
;message: The file 'E:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\2013 Jan - Feb.mdf' is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
;CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
;SqlException. Error No: 5118. Error Code: -2146232060. SeverityClass: 16
Environment
- Archiver
- Microsoft SQL server is being used as a database backend with data being stored on a compressed disk
Root Cause
Current Microsoft SQL server versions do not allow to create databases on compressed disks.
Resolution
Configure either Microsoft SQL server or GFI Archiver to create the databases on a non-compressed disk or decompress the current target drive:
- Right click the drive and open the Properties.
- Uncheck the option Compress this drive to save disk space.