Overview
If you have opted to use a Microsoft® SQL Server, Microsoft® SQL Server with File Storage or SQL Server® Express with File Storage, the article helps you to set up a new Archive Store or to configure the existing settings.
NOTE: Ensure SQL Server® is installed in Mixed Mode authentication and TCP IP is enabled.
Process
-
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 a SQL Server® from the list of discovered Microsoft® SQL Servers. Click Recheck 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.
-
Click Next to continue.
-
If, in the previous screen, you choose to manually specify the details used to store your archived emails, provide the Microsoft® SQL Server database name in the Database Server field. If a database server was selected, continue with the next step.
-
Select the authentication method used to connect to the selected SQL Server®.
-
Click Next to continue.
-
Provide the paths for the SQL Server® data (.mdf) and log (.ldf) files. If an existing database was selected, skip to the next step.
Option
Description
Use the default path as defined in the Microsoft SQL Server.
Instructs GFI Archiver to use the default paths configured within SQL Server®. Uncheck this option to set alternate paths.
Data file location
Defines the location used by GFI Archiver to store data files. Key in or click Browse to select the path.
Use the same path for both the data file and log file.
Instructs GFI Archiver to use the path in the Data & Log File Location text box 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 Archiver to store the log files. Enter or click Browse to select the path.
-
Click Next to continue.
-
Provide the file locations required for the type of selected SQL Server® type.
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.
Use the following login and password 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.
Search Index location
Defines the location where the email search index will be located. Enter or click Browse to select a location where to store this file.
NOTE
UNC paths are allowed, provided that the Search service has read/write access to the location. For more information refer to Configuring Index File Location Credentials.
-
Click Next to continue.
Important: For more information refer to Choosing your database type.
-
(Optional) Check the Create a new Archive Store now option to let GFI Archiver create the first archive store. A welcome email is sent by GFI Archiver to confirm that the new archive store has been created.
-
Click Finish.