*======================================================================*
* *
* IBM Tivoli Storage Manager for Databases *
* *
* Data Protection for Microsoft SQL Server *
* *
* Sample Options File *
* *
*======================================================================*
CLUSTERnode NO
PASSWORDAccess Generate
*======================================================================*
* TCP/IP Communication Options *
*======================================================================*
COMMMethod TCPip
TCPServeraddress TSM_Server_name
TCPPort 1500
TCPWindowsize 63
TCPBuffSize 32
*======================================================================*
* Named Pipes Communication Options *
*======================================================================*
*COMMMethod NAMEdpipe
*NAMedpipename \\.\pipe\tsmpipe
*======================================================================*
* - Compression Options *
* *
* Use the "COMPRESSION" option to compress the data before sending *
* it to the IBM Tivoli Storage Manager server. Use the *
* "COMPRESSALWAYS" option to specify whether to continue compressing *
* the data if it grows during compression. *
* *
*======================================================================*
COMPRESSIon NO
*COMPRESSAlways NO
*======================================================================*
* *
* - Scheduling Options *
* *
* The default scheduling mode is the client polling method. *
* To use server prompted scheduling, you must be sure to use a tcp *
* client port different than the one used by the regular backup *
* client. *
* *
*======================================================================*
SCHEDMODE Polling
*SCHEDLOGRetention 14
*SCHEDMODE Prompted
*TCPCLIENTADDRESS yy.yy.yy.yy
*TCPCLIENTPORT 1502
*======================================================================*
* Include/Exclude Processing *
* *
* For a more complete description of include/exclude processing refer *
* to the Data Protection for Microsoft SQL Server Installation and *
* User's Guide. *
*======================================================================*
*======================================================================*
* The following include statements assign all meta objects to *
* management class SqlDbMetaMgmtClass and all data objects to *
* SqlDbDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\*" SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*" SqlDbDataMgmtClass
*======================================================================*
* The following include statements assign all log meta objects to *
* management class SqlLogMetaMgmtClass and all log data objects to *
* SqlLogDataMgmtClass *
*======================================================================*
*INCLUDE "\...\meta\...\log*" SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*" SqlLogDataMgmtClass
*======================================================================*
* The following exclude statements exclude all log backups for *
* databases master and msdb *
*======================================================================*
EXCLUDE "\...\master\...\log*"
EXCLUDE "\...\msdb\...\log*"
EXCLUDE "\...\model\...\log*"
EXCLUDE "\...\distribution\...\log*"
EXCLUDE "\...\dba\...\log*"
*======================================================================*
* The following exclude statement excludes the "db1" database *
* from being compressed (if compression is enabled for backups.) *
*======================================================================*
*EXCLUDE.COMPRESSION "\...\db1\...\*"
NOdename sql01dev_sql