Return
-
Title
How to limit, delete or archive excessive date for Log Shipping -
Description
LiteSpeedLocal.LogShippingHistory, LiteSpeedLocal.Activity, LiteSpeedLocal database and LiteSpeedCentral databases may grow to be large or unmanageable if there are many updates from LiteSpeed Log Shipping.
-
Resolution
WORKAROUND: Manually remove data. Set LiteSpeedLocal and/or LiteSpeedCentral to SIMPLE recovery mode.
RESOLUTION:
Beginning with Version 6.x, there is a "Clean Up History" task on Maintenance Plans.
The task includes the following choices:
Select the historical data to delete
Backup & Restore History, SQL Server Agent job history, Maintenance Plan History
LiteSpeed historical data:
LiteSpeed activity history from Local Repository
LiteSpeed activity history from Central RepositoryAdditional deleting options for Local and Central Repository:
ny information for deleted databases
Log shipping history
Status history (Job, DTS, Maintenance Plan) - requires "SQL Server Agent Job History" be selectedRemove historical data older than "X" -
Defect ID
ST61019