I get the same error every now and then.
Here is the .opt file:
*======================================================================*
* *
* IBM Tivoli Storage Manager for Databases *
* *
* Data Protection for Microsoft SQL Server *
* *
* Sample Options File *
* *
*======================================================================*
NODename AT-FACET-DB03_TDP
CLUSTERnode NO
PASSWORDAccess Generate
*======================================================================*
* TCP/IP Communication Options *
*======================================================================*
COMMMethod TCPip
TCPServeraddress 172.17.1.219
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 10
*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*"
*======================================================================*
* The following exclude statement excludes the "db1" database *
* from being compressed (if compression is enabled for backups.) *
*======================================================================*
*EXCLUDE.COMPRESSION "\...\db1\...\*"
And the SQLFULL.CMD file:
@ECHO OFF
rem ==================================================================
rem sqlfull.smp sample command file
rem
rem Sample command file containing commands to do a scheduled full
rem backup of all SQL databases to an IBM Tivoli Storage Manager
rem server.
rem
rem This file is meant to be executed by the IBM Tivoli Storage
rem Manager central scheduler in response to a defined schedule on
rem the IBM Tivoli Storage Manager server.
rem
rem ==================================================================
rem ==================================================================
rem Replace "C:" with the drive where Data Protection for SQL
rem is installed. Update the directory to match the installation
rem directory that you chose when you installed the product.
rem ==================================================================
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
rem ==================================================================
rem The two lines below put a date/time stamp in a log file for you.
rem Note: You can change "sqlsched.log" to whatever you prefer in
rem lines below.
rem ==================================================================
date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log
rem ==================================================================
rem Now call the command-line interface to do the backup:
rem
rem Replace "srvrname" with the name of the options file name you
rem plan to use.
rem
rem If SQL authentication is being used and the SQL login settings have
rem not been stored via the GUI, you must also specify the /sqluser and
rem /sqlpassword options on the command below.
rem
rem In this example, we use the '*' to back up all of the databases
rem on the SQL server. Note that database 'tempdb' will not
rem be backed up.
rem
rem Note: You can change "sqlsched.log" and "sqlfull.log" to
rem whatever you prefer.
rem ==================================================================
%sql_dir%\tdpsqlc backup NPITEST431,NPITEST431xc full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.log >> %sql_dir%\sqlsched.log
Any assistance would be greatly appreciated.
Thanks,
Danny
