Phone Lines icon GFI Support

Articles in this section

See more

Changing the Initial Size of the SQL Database Automatically Created by GFI Archiver

Author: Luis Fernandes Updated

Overview

This article describes the process to change the initial database created by GFI Archiver. When GFI Archiver creates a new Archive Store, the Microsoft SQL database expands the database files to 1.1GB in size by default:

  • MDF file: 1024MB 
  • LDF file: 100MB

Process

To change the initial database size that GFI Archiver will create, please do the following:

NOTE: This procedure requires to edit files manually. If edited incorrectly it can leave the server in a non-operational state. Please keep backups of any file which is edited throughout this article before saving any changes to them.

  1. Stop the GFI Archiver Store service.
  2. Open the file ..\GFI\Archiver\Store\Data\product.config in Notepad.
  3. Find the following two lines: 
    <add key="DBInitialSize" value="1024" />   
    <add key="DBAutoGrowth" value="100" />
  4. Change the value of these keys to the desired value in MB:
    • DBInitialSize refers to the initial size of the MDF file.
    • DBAutoGrowth refers to the initial size of the LDF file (the transaction log) and also defines its autogrowth (how much the file increases in size each time).
  5. Save the file.
  6. Start the GFI Archiver Store service.


IMPORTANT!

  • Changing these settings does not have any effect on existing databases. It only affects the process when new databases are being created.
  • When upgrading to a newer version of GFI Archiver, installation files mentioned in this procedure will be overwritten with default versions making the changes void and ineffective. It is therefore suggested to keep a record of this procedure and follow it once again directly after upgrading to keep this functionality intact.