Archive

If the Archive settings are grayed out, it's because an archive database needs to be setup on the Connections tab.

Note:
Due to database schema changes from products earlier than ELM 6.5, only Reports will return data from an archive.

The Archive database is an optional database that can be used to minimize the size of the ELM primary database, improving the responsiveness of the ELM Console.  There is also a rollover option to provide generational archives based upon a default 365 day time frame or by size, the default 9 GB for SQL Express or 50GB for Standard/Enterprise versions.

Note:
ELM checks the size of the archive database prior to the archive event and will create a new archive if the size exceeds 50GB.  Because of when this check occurs you will have an archive over 50GB.  Example: If you current archive is 49GB and you archive 7GB of data, you will then have an archive of 56GB. The next time the archive event occurs ELM will now see it is over the 50GB size limit and create a new archive. Changing to different  database sizes requires direct editing of the databaseSettings.xml file

Once the archives are created, the ELM Console can be connected to these historical databases for ad hoc reports or forensic investigation by Right clicking on Viewing and Notifying in the ELM Console and selecting "Connect Archive Database". The Server can be a local or remote Microsoft SQL instance. If a named instance of SQL is used, enter the server name using the pattern: servername\instancename.