IMPORTANT

Failing to follow the above recommendations may result in substantial performance degradation.

NOTE

Archive email auditing feature is only available when emails are archived in SQL Server®. Microsoft® SQL Server with File Storage option is not supported.

2.5.3 Using SQL Server®

Express

SQL Server®Express is recommended for medium sized organizations (approximately 1-100 email users) with an average mail flow of up to 6000 emails/day.

The recommended setup for GFI Archiver using a SQL Server®Express 2005/2008/2012/2014 database is as follows:

Physical HDD 1:Operating system and GFI Archiver installation. Physical HDD 2:Microsoft®SQL Server data file (.mdf).

Physical HDD 3:Microsoft®SQL Server log file (.ldf) Physical HDD 4:Mail database indexes.

IMPORTANT

Ensure that the .mdf and .ldf files are stored in a folder on the destination drive and not in the root directory.

This configuration ensures that different processes are distributed to distinct physical hard disk drives, where email metadata (information about the email) is stored in the database while the actual email content resides as files on separate disk. This eliminates performance loss due to excessive data read/write operations on the same physical hard disk drive. For more information on how to install different versions of Microsoft SQL Server Express visitthe Microsoft SQL Server

website.

NOTE

Archive email auditing feature is only available when emails are archived in SQL Server®. Microsoft® SQL Server with File Storage option is not supported.

There are however a number of SQL Server®Express limitations to consider:

Database size has a limit of 10GB (for SQL Server®Express 2008 R2 and later only). This does not affect the amount of data that can be stored in a database.

It uses 1 CPU only

It uses a maximum of 1GB RAM. It is therefore highly recommended that:

OPTION DESCRIPTION

SQL Server Express and file system are used as the back-end database.

This method uses SQL Server®Express as the backend database and a separate location (not a database) for the binary sources files. This saves up on the SQL Server®Express space required for archiving. For example, an email of 5MB is stored by saving the email header (60kb in size) in the database and the actual email content (5MB) in the separate location.

Use only Monthly or BiMontly sched- ules based on your email volumes

GFI Archiver automatically creates archive stores based on the pre- defined schedule. For SQL Express each database should

approximately have less than 0.5 million emails. For more information refer toScheduling Archive Stores(page 169).

NOTE

If an Archive Store exceeds the maximum database size, GFI Archiver automatically creates a new Archive Store based on the configuredNew Archive Store Settings. This feature is only available for Archive Stores based on SQL Server®Express databases.

IMPORTANT

Configure Microsoft®SQL Server®Express to use Mixed Authentication mode for use with GFI Archiver.

2.5.4 Using Microsoft®

SQL Server

Microsoft®SQL Server is recommended for larger organizations (100+ email users) with a substantial volume of emails to archive (more than 6000 email per day). For organizations with more than 500 email users (or more than 8000 emails per day) to archive emails for, it is highly recommended to use Microsoft®SQL Server with File Storage option. This substantially increases the archival capacity of GFI Archiver. For more information on how to install different versions of Microsoft SQL Server visit the Microsoft Developer Network website.

NOTE

Archive email auditing feature is only available when emails are archived in Microsoft®SQL Server. For Microsoft®SQL Server with File Storage option you can use the GFI Archiver Auditing features instead. For more information refer toConfiguring Auditing(page 205).

The recommended setup for GFI Archiver using a Microsoft®SQL Server 2000/2005/2008 database is as follows:

Physical HDD 1:Operating system and GFI Archiver installation. Physical HDD 2:Microsoft®SQL Server data file (.mdf).

Physical HDD 3:Microsoft®SQL Server log file (.ldf) Physical HDD 4:Mail database indexes.

IMPORTANT

Ensure that the .mdf and .ldf files are stored in a folder on the destination drive and not in the root directory.

This configuration ensures that different processes are distributed to distinct physical hard disk drives. This eliminates performance loss due to excessive data read/write operations on the same physical hard disk drive.

NOTE

After the first month of archiving, note the database data file size. With this value, estimate the archive database size after six months, for example. If you estimate that your archive database will be larger than 20 GB, you should consider configuring the Archive Stores management feature of GFI Archiver.

IMPORTANT

To change to Mixed Authentication mode:

1. Right-click on theSQL Server node > Propertiesfrom the Enterprise Manager 2. Access Security tab and selectSQL Server and Windowsunder Authentication. 3. Save settings.

2.6 Installing GFI Archiver

1. Double-click on:

Archiver.exeto install GFI Archiver on 32-bit systems Archiver_x64.exeto install GFI Archiver on 64-bit systems

2. In theChoose Setup Languagedialog, select the language you want to use during installation and clickOK.

3. On theWelcomepage, clickNext.

4. (Optional) If the Installation Wizard detects any required missing components, the prerequisites are listed in the Installation Requirements window. ClickInstall Componentsto let the Wizard install the components for you or click cancel to install them manually. ClickNext.

NOTE

If all installation requirements are met this step is skipped. For more information refer toSystem requirements(page 13).

5. If you want GFI Archiver to check for a newer build other than the one being installed, select Check for a newer build of GFI Archiver on the GFI web siteand clickNext. Otherwise, selectDo not check for a new buildand clickNext.

NOTE

Checking for a newer build requires an active Internet connection.

6. Read the license agreement and selectI accept the terms in the license agreementoption. Click Nextto continue.

7. Choose which directory service to use with GFI Archiver. GFI Archiver supports Microsoft Active Directory and GFI Directory services.

NOTE

It is recommended to use Microsoft Active Directory when available.