Historical Data Purge Scripts
Use a script to purge historical data from your DataStore at the database level as an alternative or to compliment Uptime’s built in data archiving process. Contact Support to discuss the best approach for your deployment.
MySQL
Ad-hoc
- A script that can be run ad-hoc and you specify the number of days you want retained and will trim to that date.
- To obtain this script, click the following uptime7_trim_mysql.sql
Procedure
- Creates a procedure which can then be scheduled or called ad-hoc. You set the number of daysyou want retained.
- To obtain this script, click the following uptime7_trim_mysql_loops.sql
Use Archive Settings
- Creates a procedure which can then be scheduled or called ad-hoc. The script uses the Archive retention settings to determine how many days are retained.
- To obtain this script, click the following uptime7_trim_mysql_archive.sql
Oracle
Procedure
- Creates a procedure which can then be scheduled or called ad-hoc. You set the number of days you want retained.
- To obtain this script, click the following uptime7_trim_oracle.sql
Use Archive Settings
- Creates a procedure which can then be scheduled or called ad-hoc. The script uses the Archive retention settings to determine how many days are retained.
- To obtain this script, click the following uptime7_trim_oracle_archive.sql
Index Rebuild
MS SQL
Ad-hoc
- A script that can be run ad-hoc and you specify the number of days you want retained.
- To obtain this script, click the following uptime7_trim_mssql.sql
Use Archive Settings
- A run-once script that uses the Archive retention settings to determine how many days are retained.
- To obtain this script, click the following uptime7_trim_mssql_archive.sql
