LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Store a Backup as a TSM Archive

You can run a TSM archive using xp_backup_database and xp_backup_log. For more information about the LiteSpeed extended stored procedures and command-line utilities, please refer to the LiteSpeed User Guide.

To store a backup as a TSM archive

The parameter @tsmarchive = 1 is required. The description parameter (@desc) is stored in the TSM "catalog" with any archived backup - TSM queries (via xp_view_tsmcontents) accept description patterns to enable filtering the returned list based on description.

Example:

EXEC master.dbo.xp_backup_database
@database = 'pubs'    
, @tsmclientnode = 'ClusterGroup'   
, @tsmclientownerpwd = 'test1111'   
, @tsmobject = 'SLS_Russel-Mar\pubs\(16)Thursday_14:14'  
, @tsmconfigfile = 'C:\Program Files\Tivoli\tsm\baclient\dsm.opt'  
, @desc = 'gamma test'  
, @tsmarchive = 1  
, @init = 1