LiteSpeed for SQL Server 8.6 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Purge Repository Data

Purge Repository Data

You can remove historical data using any of the following:

LiteSpeed_DeleteActivity

LiteSpeed_DeleteActivity

This stored procedure removes LiteSpeed activity and information about LiteSpeed backups based on the date and time specified. Additionally, if appropriate parameters are specified, it removes log shipping history, jobs and maintenance plans history, DST status, and information about deleted databases.

NOTE: You must run the LiteSpeed_DeleteActivity procedure against the database that has the LiteSpeed procedures installed and can be the one of the following:

  • LiteSpeedLocal.
  • LiteSpeedCentral.
  • Custom database—You can use the LiteSpeed Instance Configuration wizard (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration) to choose where to store the repository data.

This topic covers:

Syntax

USE {LiteSpeedLocal|LiteSpeedCentral|<custom_database_name>}
EXEС LiteSpeed_DeleteActivity
{ @deleteDate = 'date_time' | ( @delUnit = n,@delUnitType = 'time' )}
, {@delLocal = 0 | 1 | @delCentral = 0 | 1 |( @delLocal = 0 | 1 , @delCentral = 0 | 1)}
[, @purgeDeleted = 0 | 1 ]
[, @delLogshipping = 0 | 1 ]
[, @delStatus = 0 | 1]

Arguments

This stored procedure accepts the following arguments:

Argument Description

@deleteDate

Deletes data older than the date and time specified. The argument accepts the following format:

YYYYMMDD HH:MM:SS

where

  • YYYY—4-digit year
  • MM—2-digit month
  • DD—2-digit day of the month
  • HH—2-digit hour using the local 24-hour clock
  • MM—2-digit minute
  • SS—2-digit second

@delLocal

Deletes old data from the LitespeedActivity and LitespeedBackupFile tables in the Local repository or in the custom database (if the Local repository tables were created in the custom database). This argument accepts one of the following values:

  • 0—false
  • 1—true

@delCentral

Deletes old data from the LitespeedActivity and LitespeedBackupFile tables in the Central repository or in the custom database (if the Central repository tables were created in the custom database). This argument accepts one of the following values:

  • 0—false
  • 1—true
@delUnit

Deletes the rows older than the age specified.

@delUnitType

Specifies a unit of measurement of time for @delUnit. This argument accepts one of the following values:

  • MINUTES
  • HOURS
  • DAYS
  • WEEKS
  • MONTHS
  • YEARS
@purgeDeleted

Deletes information about deleted databases from dbo.LitespeedDatabase in the following databases:

  • Local repository or custom database, if @delLocal was supplied
  • Central repository or custom database, if @delCentral was supplied
  • Both, if both @delLocal and @delCentral were supplied

This argument accepts one of the following values:

  • 0—false
  • 1—true

@delLogshipping

Deletes old log shipping history entries from dbo.LogShippingHistory in the following databases:

  • Local repository or custom database, if @delLocal was supplied
  • Central repository or custom database, if @delCentral was supplied
  • Both, if both @delLocal and @delCentral were supplied

This argument accepts one of the following values:

  • 0—false
  • 1—true

@delStatus

Deletes old data from dbo.DbMaintStatus, dbo.DTSStatus, dbo.JobStatus in the following databases:

  • Local repository or custom database, if @delLocal was supplied
  • Central repository or custom database, if @delCentral was supplied
  • Both, if both @delLocal and @delCentral were supplied

This argument accepts one of the following values:

  • 0—false
  • 1—true

Examples

  1. Delete the following data older than 08/21/2009 from the Local and Central repositories:

    • LiteSpeed activity
    • Information about deleted databases

    exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity
    @delLocal=1
    , @delCentral=1
    , @purgeDeleted = 1
    , @deleteDate = '20090821 00:00:00'

  2. Delete the following data older than 6 months in the Local repository:

    • LiteSpeed activity
    • Log shipping history
    • Data from dbo.DbMaintStatus, dbo.DTSStatus, dbo.JobStatus

    USE LiteSpeedLocal
    EXEC LiteSpeed_DeleteActivity
    @delLocal=1,
    @delLogshipping = 1,
    @delStatus = 1 ,
    @delUnit = 6,
    @delUnitType = 'MONTHS'

 

Related Topic

Cloud

About the Cloud

About the Cloud

LiteSpeed supports backup and restore directly to and from the Microsoft Azure Blob and the Amazon S3 (Simple Storage Service) cloud storage.

Microsoft Azure Blob storage is an cloud object storage that can be used to store any data, including SQL Server database backups. Information about the Microsoft Azure Blob is available at https://azure.microsoft.com/en-us/services/storage/blobs/

Amazon S3 provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the Web. Information about the Amazon S3 is available at: http://docs.aws.amazon.com/AmazonS3/latest/dev/Introduction.html.

Note: Cloud backup and restore is only available with the Enterprise license.

 

Related Topics

Related Documents