Old t-log backup files not being deleted by Maintenance Plan that includes SmartCleanup step (xp_slsSmartCleanup).
xp_slsSmartCleanup
Removes full and differential backup files and transaction log backups based on a user-defined period (either the file age or the date).
WORKAROUND:
To delete t-log files, the t-sql script must include the parameter "(@LogRetainDays = #" and the tlogs must have aged to qualify for deletion.
exec master.dbo.xp_slsSmartCleanup
@database = 'database_name'
, (@BackupRetainDays = 1...365 | @BackupExpiration = 'date_time')
, (@LogRetainDays = 1...365 | @LogExpiration = 'date_time')
[, @CopyOnlyBackups = 'option']
[, @DryRun = 0 | 1 ]
[, @TSMClientNode = 'TSM_client_node']
[, @TSMUserName = 'TSM_username_ID']
[, @TSMPassword = 'TSM_username_password']
[, @TSMConfigFile = 'TSM_configuration_file']
[, @TSMClientOwnerPwd = 'TSM_client_owner_password']
[, @TSMDSMI_DIR = 'path']
[, @TSMDSMI_LOG = 'path']
[, @TSMLogName = 'log_name']
NOTE:
The backup retention will never delete:
For additional info on the parameters used by SmartCleanUp, see the NetVault LiteSpeed Help File.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center