Product manual

GFI MailArchiver 2 Installing GFI MailArchiver | 27
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.3.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 MailArchiver using a SQL Server
®
Express 2000/2005/2008 database
is as follows:
Physical HDD 1: Operating system and GFI MailArchiver 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.
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
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 4GB (10GB for SQL Server
®
Express 2008 R2)
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 sys-
tem 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.
Refer to the GFI MailArchiver Administration and Configuration manual (installed
with GFI MailArchiver) for detailed information on Archive Stores.
Enable the ‘Use a new Archive
Store when full’ feature within
Archive Store Management.
This instructs GFI MailArchiver to automatically switch to a new database when
the 4GB limit of SQL Server
®
Express is reached. This feature requires that
Archive Stores are based on SQL and Filesystem.
Refer to the GFI MailArchiver Administration and Configuration manual (installed
with GFI MailArchiver) for detailed information on the Use a new Archive Store
when full feature within Archive Store Management
Table 14: Microsoft SQL Server limitations