Purging Data from the Database

Space requirements for transactions in the ARM Database depend on the estimated EFT activity, number of users, and installed modules. A general estimate is 3MB to 5MB of per 1000 files uploaded. A minimum of 3GB hard drive space is recommended for the initial database size, with additional space required for growth over time.  As your database continues to grow, it is necessary to purge old records periodically.

The Helper script in (by default) C:\ProgramData\Globalscape\EFT Server Enterprise\SQL Server\Helper scripts\PurgeEFT.sql describes in which order to run the scripts to improve database performance.

For detailed information on purging the database, refer to Knowledgebase article #10426: How can I purge EFT data from my ARM database?