LiteSpeed repository maintenance - LitespeedActivity Table (4344510)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

LiteSpeed repository maintenance - LitespeedActivity Table
Description

LiteSpeed repository maintenance - LitespeedActivity Table
Cause

The LitespeedActivity Database may grow too large over time and may require archiving or maintenance.
Resolution
Purge Repository Data

You can remove historical data using any of the following:
- Clean Up History task. For more information, see About Creating Maintenance Plans on page 144 .
- SLSSQLMaint utility. For more information, see Script Maintenance Plans Tasks on page 250 .
- LiteSpeed_DeleteActivity stored procedure. For more information, see LiteSpeed_DeleteActivity on page 73 .
- Repository cleanup.
Example:

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

- LiteSpeed activity

- Information about deleted databases
```
exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity

@delLocal=1,
@delCentral=1,
@purgeDeleted = 1,
@deleteDate = '20190821 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'
```

Did this article solve an issue for you?

[Select Rating]

Title