Tech Tip - NAS_TRANSACTION_LOG table growing indefinitely
discusses a manual method to remove this data but if the problem has been undetected for a long time then these queries also fail.DECLARE @Deleted_Rows INT; SET @Deleted_Rows = 1; WHILE (@Deleted_Rows > 0) BEGIN BEGIN TRANSACTION /*Delete some small number of rows at a time*/ DELETE TOP (10000) NAS_TRANSACTION_LOG /*table name under consideration*/ WHERE TIME < DATEADD(dd,-7,getdate()) /*readTime is column name on which filtering will take place*/ SET @Deleted_Rows = @@ROWCOUNT; COMMIT TRANSACTION CHECKPOINT /*for simple recovery model*/ ENDOnce the required data is deleted please set the db recovery mode back to the desired setting.