Remove Old Data
For large databases, it may be beneficial to run this tool and remove security log data that contains no financial or clinical information.
In the Backup Tool, click Remove Old Data.
Also see: Supplemental Backups
Data removed will be limited to SecurityLog, SecurityLogHash, and EmailMessage tables from prior to the date set below.
Select the table(s) to remove data from:
Remove old data entries on or before: Select a date to remove the old data from. All securitylog data from the selected date and before will be removed.
Backup before removing data: If checked a backup will be created before the process of removing the old data is performed. We recommend making a backup prior to running this tool.
Backup Connections Settings:
Save Defaults: Save the above settings as the default to use for this tool in the future.
Remove Old Data: Run tool. This process may take a long time. Do not turn off or restart this computer until the process has completed. When running this tool, the securitylog, securityloghash, and EmailMessage data will be removed from your production database. Refer to the backup made if you need to reference this data after it has been removed.
When the tool is finished, you will get a prompt showing the number of rows removed. Click OK to finish.