Regresar
-
Título
LiteSpeed repository maintenance - LitespeedActivity Table -
Descripción
LiteSpeed repository maintenance - LitespeedActivity Table -
Causa
The LitespeedActivity Database may grow too large over time and may require archiving or maintenance. -
Resolución
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 databasesexec 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.JobStatusUSE LiteSpeedLocal EXEC LiteSpeed_DeleteActivity @delLocal=1, @delLogshipping = 1, @delStatus = 1 , @delUnit = 6, @delUnitType = 'MONTHS'