Archive

Top  Previous  Next

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 1 Month time frame or by size, the default 20 GB. Once the archives are created, the ELM Console can be connected to these historical databases for ad hoc reports or forensic investigation. 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.

All-DBSettingsArchive

By default, users have two choices as to when the Archive DB will rollover and create a new database: either once a month (the 1st of every month) or once every 20 GB. Changing to different time periods or database sizes requires direct editing of the databaseSettings.xml file.

Note:
ELM checks the size of the archive database prior to the archive event and will create a new archive if the size exceeds 20GB.  Because of when this check occurs you will have an archive over 20GB.  Example: If you current archive is 19GB and you archive 7GB of data, you will then have an archive of 26GB. The next time the archive event occurs ELM will now see it is over the 20GB size limit and create a new archive.