We have a TSM retention policy that specifies to retain a certain number of backup files. I want to backup transaction logs every hour; how can I do this to TSM without having to specify numerous files?
The LiteSpeed extended stored procedure 'xp_backup_log' can use TSM parameters similarly to SQL Server native command 'backup database'. TSM does not differentiate between a full or log or differential backup file, if the backup is from SQLLiteSpeed. The files will be retained per the retention policy assigned to that management class (the default management class or the management class specified in the @tsmmanagmenetclass parameter).
TSM retention manages backup file retention. To view the backup files that have been retained, run the xp_view_tsmcontents.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center