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
Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement