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<[email protected]> 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 > [email protected] > >
