Search

Thursday, July 28, 2011

Script to taking tsm backups with litespeed

Example script for taking tsm backups with litespeed

master.dbo.xp_backup_database @database = [Testdb],
@tsmconfigfile = 'd:\Program Files\Tivoli\TSM\TDPSql\dsm.opt',
@tsmobject = 'SDWPCE1D_EDH\CONTROLS\CONTROLS-082207-000000-0-FUL',
@desc = 'Some description',
@backupname = 'testdb FUL',
@with = SKIP,
@compressionlevel = 2,
@init = 1,
@OLRMAP = 1
===========================================================
master.dbo.xp_backup_database @database =[model], @TSMObject = 'SERVER1-SQL1SQL1/model\dbbackup\FULL', @TSMConfigFile = 'D:\SERVER1-SQL1_LS\dsm.opt', @desc = 'Full Backup LS to TSM', @TSMArchive = 1, @init = 1

No comments:

Post a Comment