Over time, audit data builds up in the database causing performance issues. This article shows you how to migrate old audit data to a new database, so that you can free up valuable resources and speed up performance.
Prerequisites
Before you begin, please ensure you do the following to ensure a smooth move,
Go to your RecordPoint Site and navigate to Management > Settings > Storage Settings. Note down the Site URLs and Database Names of the Storage Site Locations for future reference.
Ensure you have a new database set up in your SQL Server Management Studio (or similar software) to move the Audit Data into. You do not have to create a new table, as it will be automatically created during the move.
Migration Steps To Move Old Audit Data to a New Database
Copy the AuditData table from the storage site database (the one you noted down previously) into a new database by running the following SQL query. Note that this query will take several minutes to complete depending on the size of your database.
...