Below is my dsm.opt file. You must specify the "tcpclientaddress" when
you used the service scheduler, otherwise it won't work. So you can
change the nodename, tcpserveraddress, tcpclientaddress,tcpclientport, and
the mgt class. For tcpclientaddress you may use the tcp/ip address or the
hostname.
DSM.opt
*======================================================================
* DSM.OPT file for TDP 2.2
*Tivoli Data Protection for Microsoft SQL Server *
*
*======================================================================
NODename vc3000hc_SQL2
CLUSTERnode no
COMPRESSIon no
PASSWORDAccess Generate
*======================================================================*
* TCP/IP *
*======================================================================
COMMMethod TCPip
TCPPort 1500
TCPServeraddress adsm12gb
TCPWindowsize 63
TCPBuffSize 32
*======================================================================
* - 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
schedlogname c:\adsm\tdpsql\tdpsql.log
errorlogname c:\adsm\tdpsql\tdpsql.error
SCHEDLOGRetention 7,d
errorlogretention 14,d
SCHEDMODE Prompted
TCPCLIENTADDRESS vc3000hc
TCPCLIENTPORT 1502
*======================================================================
* Include/Exclude Processing
* For a more complete description of include/exclude
processing see
* the Tivoli Data Protection for Microsoft SQL Server Installation and
* User's Guide (Chapter 3 and Appendix B)
*======================================================================
INCLUDE * MC100
*======================================================================*
* 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*"
