You can remove historical data using any of the following:
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:
This topic covers:
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]
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
|
|
@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:
|
|
@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:
|
| @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:
|
| @purgeDeleted |
Deletes information about deleted databases from dbo.LitespeedDatabase in the following databases:
This argument accepts one of the following values:
|
|
@delLogshipping |
Deletes old log shipping history entries from dbo.LogShippingHistory in the following databases:
This argument accepts one of the following values:
|
|
@delStatus |
Deletes old data from dbo.DbMaintStatus, dbo.DTSStatus, dbo.JobStatus in the following databases:
This argument accepts one of the following values:
|
Delete the following data older than 08/21/2009 from the Local and Central repositories:
exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity
@delLocal=1
, @delCentral=1
, @purgeDeleted = 1
, @deleteDate = '20090821 00:00:00'
Delete the following data older than 6 months in the Local repository:
USE LiteSpeedLocal
EXEC LiteSpeed_DeleteActivity
@delLocal=1,
@delLogshipping = 1,
@delStatus = 1 ,
@delUnit = 6,
@delUnitType = 'MONTHS'
LiteSpeed supports backup and restore directly to and from the following.
Note: Cloud backup and restore is only available with the Enterprise license.
Microsoft Azure Blob storage is a 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.
Google Cloud Storage is unified object storage for developers and enterprises, from live data serving to data analytics/ML to data archiving. LiteSpeed supports Multi-Regional, Regional, Nearline and Coldline storage types. More information on Google Cloud Storage is available at https://cloud.google.com/storage.
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
