The .CMD file:

@ECHO OFF
set sql_dir=C:\Progra~1\Tivoli\TSM\TDPSql
C:
cd %sql_dir%
date < NUL >> %sql_dir%\sqldiff.log
time < NUL >> %sql_dir%\sqldiff.log
%sql_dir%\tdpsqlc backup * diff /tsmoptfile=%sql_dir%\sqldiff.opt
/logfile=%sql_dir%\sqldiff.log


The .OPT file:

NODename          SAPSERVER_SQL
CLUSTERnode       NO
PASSWORDAccess    Generate
SCHEDLOGRET       7
COMMMethod        TCPip
TCPServeraddress  TSM-SERVER-3
TCPPort           1500
TCPWindowsize     63
TCPBuffSize       512
COMPRESSIon       ON
SCHEDMODE             Prompted
EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"
EXCLUDE "\...\Test*\...\*"
EXCLUDE "\...\TEST*\...\*"

The .LOG:
The current date is: Wed 07/29/2009
Enter the new date: (mm-dd-yy) The current time is: 17:20:08.06
Enter the new time: 07/29/2009 17:20:08 ============== Log file pruned
using log retention period of 14 day(s)
07/29/2009 17:20:08 ============== No log entries pruned
07/29/2009 17:20:08
=========================================================================
07/29/2009 17:20:08
=========================================================================
07/29/2009 17:20:08 Request                       : DIFF BACKUP
07/29/2009 17:20:08 Database Input List           : *
07/29/2009 17:20:08 Group Input List              : -
07/29/2009 17:20:08 File Input List               : -
07/29/2009 17:20:08 Number of Buffers             : 3
07/29/2009 17:20:08 Buffer Size                   : 1024
07/29/2009 17:20:08 Number of SQL Buffers         : 0
07/29/2009 17:20:08 SQL Buffer Size               : 1024
07/29/2009 17:20:08 Number of Stripes specified   : 1
07/29/2009 17:20:08 Estimate                      : 20
07/29/2009 17:20:08 Truncate Log?                 : -
07/29/2009 17:20:08 Wait for Tape Mounts?         : Yes
07/29/2009 17:20:08 TSM Options File              :
C:\Progra~1\Tivoli\TSM\TDPSql\sqldiff.opt
07/29/2009 17:20:08 TSM Nodename Override         : -
07/29/2009 17:20:08 Sqlserver                     : SAP-SRV
07/29/2009 17:20:08
07/29/2009 17:20:09 Backup of SQL Database SBODemoHE will not be attempted.
07/29/2009 17:20:09 SQL Database Status: Offline
07/29/2009 17:20:09 ACO5422E Received the following from the MS SQL server:
07/29/2009 17:20:09 An exception occurred while executing a
Transact-SQL statement or batch.
07/29/2009 17:20:09 Database 'SBODemoHE' cannot be opened because it
is offline. (HRESULT:0x80131501)
07/29/2009 17:20:09 Backup of SQL Database Test_1907 will not be attempted.
07/29/2009 17:20:09 SQL Database Status: Offline
07/29/2009 17:20:09 ACO5422E Received the following from the MS SQL server:
07/29/2009 17:20:09 An exception occurred while executing a
Transact-SQL statement or batch.
07/29/2009 17:20:09 Database 'Test_1907' cannot be opened because it
is offline. (HRESULT:0x80131501)
07/29/2009 17:20:09 Backup of SQL Database TEST_2306 will not be attempted.
07/29/2009 17:20:09 SQL Database Status: Offline
07/29/2009 17:20:09 ACO5422E Received the following from the MS SQL server:
07/29/2009 17:20:09 An exception occurred while executing a
Transact-SQL statement or batch.
07/29/2009 17:20:09 Database 'TEST_2306' cannot be opened because it
is offline. (HRESULT:0x80131501)
07/29/2009 17:20:16 Total SQL backups selected:               10
07/29/2009 17:20:16 Total SQL backups attempted:              4
07/29/2009 17:20:16 Total SQL backups completed:              4
07/29/2009 17:20:16 Total SQL backups excluded:               3
07/29/2009 17:20:16 Throughput rate:                          4,073.99 Kb/Sec
07/29/2009 17:20:16 Total bytes transferred:                  28,981,248
07/29/2009 17:20:16 Elapsed processing time:                  6.95 Secs
07/29/2009 17:20:16 ACO0151E Errors occurred while processing the request.

--
Warm regards,
Michael Green



On Wed, Jul 29, 2009 at 5:08 PM, Tchuise,
Bertaut<BTchuise AT lmus.leggmason DOT com> wrote:
> Michael,
>
> You are correct about the shortcomings of specifying what to backup and what 
> to exclude. The syntax for your exclude statements below is correct; can you 
> send short extracts from the TDP logs for the errors you are getting?
>
> BERTAUT TCHUISE
> Storage Support Administrator
> Legg Mason Technology Services
> *410-580-7032
> BTchuise AT leggmason DOT com
>
>