When user tried to run the command (exec LiteSpeedLocal..LiteSpeed_DeleteActivity @delLocal=1, @delCentral=1, @purgeDeleted=0, @delLogshipping=1,@delStatus=1, @deleteDate='20110110 13:01:00') it did not purge all data and log file growth?
(1) Using DELETE TOP that restricts number of deleted rows. Then run BACKUP LOG and DBCC SHRINKFILE
USE [LiteSpeedLocal]
DECLARE @n int
SET @n = 1000
DELETE TOP (@n) FROM dbo.JobStatus WHERE RunTime < 'YYYY-MM-DD'
(2) Using TRUNCATE TABLE - it will purge all table data (!)
The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. TRUNCATE TABLE is functionally the same to the DELETE statement without a WHERE clause. However, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
TRUNCATE TABLE dbo.JobStatus
After purging, apply the same suggestion as before - schedule cleanup more often and with more recent date to avoid large delete transaction in future.
