I am trying to get my head around how to effectively set up backup and archiving the ESM database,
1. You can store the content on iSCASI or a SAN but not offline.
If click on Database | Data Allocation there is a message "Configure how much space the database should allocate for Events and Flows by specifying the number of records for each table. The total size is a fixed value. These settings may affect the data retention policy."
So, whichever happes first