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

• GFI 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:

1. Right click the drive and open the Properties.
2. Uncheck the option Compress this drive to save disk space.