Configure Archive Store - Microsoft SQL Server

If you have opted to use a Microsoft SQL Server, Microsoft SQL Server with File Storage or Microsoft SQL Express with File Storage, you will now be asked to set up a new Archive Store.

Screenshot 10: Archive Store Creation: Provide Archive Store name.

1. In the Archive Store Details screen, key in an Archive Store name, select whether to allow users to use the new Archive Store and the method used to create it.

OPTION DESCRIPTION

Archive Store Name Defines the name of the new Archive Store.

Table 19: Archive Store creation options

OPTION DESCRIPTION Allow users to browse and search this

Archive Store

Enables users to browse and search Archive Store. Uncheck this option to prevent users from searching for and viewing emails archived within this Archive Store.

Users and the System will only be allowed to browse the Archive Store without updating

Enable this option to restrict users to viewing archived email data in the Archive Store without making any changes to it.

NOTE: This option is not available when creating your first Archive Store.

Wizard Defines the method used by GFI MailArchiver to create the new archive store.

Use this option to have a wizard assist you in creating a new archive store.

Archive Store Profile Defines the method used by GFI MailArchiver to create the new archive store.

Use this option to use the previously saved settings of an Archive Store that has been already created.

NOTE: This option is not enabled if you are creating your first Archive Store.

Click Next to continue setup.

Screenshot 11: Archive Store creation: Select database

2. In the Database Server Details screen, choose an SQL Server from the list of automatically discovered servers or manually provide the details.

OPTION DESCRIPTION Select the database server to

use to store the archived emails.

Enables you to select an SQL Server from the list of discovered SQL Servers. Click Recheck button to recheck for any servers that might have come online since the page loaded.

Manually specify the database server to use to archive your emails.

Choose this option to disregard the list of discovered Microsoft SQL Servers and to specify the details of the server used for your Archive Store.

Table 20: Database server details

Click Next to continue.

3. If in the previous screen you have chosen to manually specify the details used to store your archived emails, provide the SQL Server database name in the Database Server field. If a database server was selected, continue with the next step.

4. Select the authentication method used to connect to the selected SQL Server.

OPTION DESCRIPTION

Integrated Windows Authentication

Uses the login credentials of the currently logged on user to access the Microsoft SQL Server.

Keying in a username and a password is not required.

Microsoft SQL Server Authentication

Uses the username and password provided in the Username and Password fields to access the Microsoft SQL Server.

Table 21: Archive Store authentication options

Click Next to continue.

5. Select a database or create a new one within the previously selected Microsoft SQL Server.

OPTION DESCRIPTION

Select and existing Database Select a database to use for the new Archive Store from the list displayed.

Create a new database Choose this option to have GFI MailArchiver create a new database for you.

Table 22: Archive Store database selection options

Click Next to continue.

Screenshot 12: Archive Store creation: Select data and log file location.

6. If in the previous screen you have selected to create a new database, provide the paths that will be used by the Microsoft SQL Server data (.mdf) and log (.ldf) files. If an existing database was selected, continue with the next step.

OPTION DESCRIPTION

Use the default path as defined in the Microsoft SQL Server

Instructs GFI MailArchiver to use the default paths configured within Microsoft SQL Server. Uncheck this option to be able to configure alternate paths.

Data file location Defines the location used by GFI MailArchiver to store the data files. Key in or click Browse… to select the path.

Use the same path for both data file and log file.

Instructs GFI MailArchiver to use the path selected or keyed in the Data File Location textbox as the location for the Log file.

Uncheck this option to key in a custom log file location.

Log File Location Defines the location used by GFI MailArchiver to store the log files. Key in or click Browse… to select the path.

Table 23: Archive Store database file location options

Click Next to continue.

Screenshot 13: Archive Store creation: Select locations

7. Provide the file locations required for the type of Microsoft SQL server selected.

NOTE

Some options are not selectable depending on the type of Microsoft SQL Server selected.

For example, selecting Microsoft SQL Server with File Storage disables Database File Location and Email File Location options.

OPTION DESCRIPTION

Email file location Defines the location where the email data will be located. Key in or click Browse… to select a location where to store this file.

NOTE

UNC paths are allowed.

Table 24: Database file location options

OPTION DESCRIPTION

Search Index location Defines the location where the email search index will be located. Key in or click Browse… to select a location where to store this file.

NOTE

UNC paths are not allowed.

Use the following credentials to access the above UNC path

Enable this option to allow input in the Login: and Password: fields. The credentials keyed in will be used to access the UNC paths selected.

Click Next to continue.

IMPORTANT

Refer to the Choosing and Preparing a Database section within the Installing GFI MailArchiver chapter for detailed information on how to best configure your Microsoft SQL Server database for GFI MailArchiver.

6. In the Archive Store Summary screen, click Create to start creating new Archive Store.

7. Click Finish to complete new Archive Store creation.