Launch the Services management console from Start > Run and type ‘services.msc’

4. Stop all GFI MailArchiver services.

5. Using the search index path determined in step 2, backup the Archive Stores’ search indexes, either by manually copying and pasting the search index folder or using a backup utility.

Screenshot 72: Backup an SQL database

6. From the SQL Server^®, launch the Microsoft^®SQL Server Manager and backup the archive database noted in step 2. To backup a database, right-click on the database and select Tasks > Back up….

NOTE

A maintenance plan can be created in SQL Server^®to schedule periodic backups of the archive database.

7. Return to the GFI MailArchiver server and from the Services management console, restart all GFI MailArchiver services.

GFI MailArchiver 7 Configuring GFI MailArchiver|126

Backup Archive Store Based on Microsoft^®SQL Server and File System In this type of Archive Store, the following information is stored:

Archived email metadata - Stored on the Microsoft^®SQL Server database.

Compressed email binary source - Stored on disk.

Search index entries - Stored on disk.

To backup an Archive Store:

1. From GFI MailArchiver, go to Configuration > Archive Stores and click 2. Take note of the following information for quick reference:

Server Database

Path to email binary source Path to search index

NOTE

Move pointer over the path to view the full path.

3. Launch the Services management console from Start > Run and type ‘services.msc’.

4. Stop all GFI MailArchiver services.

5. Using the paths determined in step 2, backup the Archive Stores’ email binary source and search index, either by manually copying and pasting the folders or using a backup utility.

GFI MailArchiver 7 Configuring GFI MailArchiver|127 Screenshot 73: Backup an SQL database

6. From the Microsoft^®SQL Server, launch the Microsoft^®SQL Server Manager and backup the archive database noted in step 2. To backup a database, right-click on the database and select Tasks > Back up….

NOTE

A maintenance plan can be created in Microsoft^®SQL Server to schedule periodic backups of the archive database.

7. Return to the GFI MailArchiver server and from the Services management console, restart all GFI MailArchiver services.

Backup Archive Store Based GFI MailArchiver (Firebird) Database And File System In this type of Archive Store, the following information is stored:

Archived email metadata - Stored on disk.

Compressed email binary source - Stored on disk.

GFI MailArchiver 7 Configuring GFI MailArchiver|128

Search index entries - Stored on disk.

To backup an Archive Store:

1. From GFI MailArchiver, navigate to Configuration > Archive Stores and click . 2. Store the following paths for quick reference:

Path to Firebird database Path to email binary source Path to search index

NOTE

Move pointer over the path to view the full path.

3. Launch the Services management console from Start > Run and type ‘services.msc’.

4. Stop all GFI MailArchiver services.

5. Using the paths determined in step 2, backup the Archive Stores’ database file, binary files and search indexes, either by manually copying and pasting the files in a backup location or using a backup utility.

6. From the Services management console, restart all GFI MailArchiver services.

Restoring an Archive Store Which is Added in GFI MailArchiver

1. From GFI MailArchiver, navigate to Configuration > Archive Stores and click

2. From the Archive Store Statistics dialog, note the following properties for quick reference:

TYPE OF ARCHIVE STORE

ARCHIVE STORE PROPERTIES

Microsoft^®SQL Server Server Database

Path to email binary source Path to search index Firebird Database Path to Firebird database

Path to email binary source Path to search index Table 70: Archive Store properties

3. Launch the Services management console from Start > Run and type ‘services.msc’.

4. Stop all GFI MailArchiver services.

5. Refer to the location of files noted in step 2 to override the Archive Store files with the restored backup files as follows:

GFI MailArchiver 7 Configuring GFI MailArchiver|129

Firebird database - replace the Firebird database on disk with the backed up Firebird database SQL database - from the Microsoft^®SQL Manager right-click the backed up database and select Tasks > Restore.

Email binary source - replace the binary folder on disk with the backed up binary folder Search index folder - replace the Search index folder on disk with the backed up Search index folder.

6. From the Services management console, restart all GFI MailArchiver services.

Restoring an Archive Store Which is not Added in GFI MailArchiver

1. Depending on the type of Archive Store to restore, restore the applicable backed up data as follows:

Firebird database - restore the Firebird database on disk

SQL database - from the Microsoft SQL Manager right-click the backed up database and select Tasks > Restore.

Email binary source - restore the binary folder on disk Search index folder - restore the search index folder on disk Take note of the paths where all data has been restored.

2. Add the restored Archive Store in GFI MailArchiver ensuring that all paths configured during the wizard, for example search index path or SQL database, are the paths of the restored data.

7.8.12 Moving Emails From One Database to Another

GFI MailArchiver supports various types of Archive Stores. The software enables you to move emails from one database to another or to many other databases.

NOTE

This feature is only applicable when moving the original emails source stored on disk of a Firebird database or SQL Server^®file system. Emails cannot be moved from a SQL Server^®database when the source is stored on the SQL Server^®database.

Examples:

A Firebird database becomes very large in size and hence slow to load data, so the administrator decides to switch to a SQL Server^®database.

An SQL file system stored on disc, stores emails of one whole year. It is recommended to separate the emails to multiple databases, for example one database for each month.

Important Notes

1. It is highly recommended to backup the archive stores before moving emails. This process is described in theBackup Archive Storeschapter of this manual.

2. Moving emails between archive stores requires a high amount of computer processing resources and can reduce the performance of the GFI MailArchiver server substantially.

GFI MailArchiver 7 Configuring GFI MailArchiver|130

3. The folder structure of emails is lost when moving emails, however the emails can be

resynchronized to retrieve the folder structure. The folder structure of emails deleted from the mailbox is permanently lost.

4. Ensure that the new database where emails are going to be moved to, is added in the GFI

MailArchiver Archive Stores. This process is described in theManaging Archive Storeschapter of this manual.

5. Multiple databases can be created to cover different emails date ranges.

7.8.13 Upgrading the Database Schema

It is important that all Database Schemas are upgraded to the latest schema to ensure GFI

MailArchiver works correctly. This process can be carried out either during theupgrade process(by the Installation Wizard) or at a later stage using the Bulk Schema Upgrader.

Use the Bulk Schema Upgrader to:

Upgrade the GFI MailArchiver database schemas or Verify that you are using the latest database schema To launch the Bulk Schema Upgrader:

1. From the GFI MailArchiver machine, go to the GFI MailArchiver installation folder, open BulkSchemaUpgrader folder and click BulkSchemaUpgrader.exe.

Screenshot 74: The Bulk Schema Upgrader