Michael,

Thanks for the extracts, I didn't see any error pertaining to the TEST
databases specifically but as you saw it from the logs, you are getting
failures because you have a few databases offline.

Step 2 in this link explains that despite excluding databases, TDP will
generate errors - "There is no method to exclude an SQL db that is
offline without it being scanned first".

http://www-01.ibm.com/support/docview.wss?rs=3040&context=SSRUNY&uid=swg
21269094&loc=en_US&cs=UTF-8&lang=en

BERTAUT TCHUISE
Storage Support Administrator
Legg Mason Technology Services
*410-580-7032
BTchuise AT leggmason DOT com

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Michael Green
Sent: Wednesday, July 29, 2009 10:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP MSSQL excludes

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
>
>

IMPORTANT:  E-mail sent through the Internet is not secure. Legg Mason 
therefore recommends that you do not send any confidential or sensitive 
information to us via electronic mail, including social security numbers, 
account numbers, or personal identification numbers. Delivery, and or timely 
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends 
that you do not send time sensitive 
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain privileged or 
confidential information. Unless you are the intended recipient, you may not 
use, copy or disclose to anyone any information contained in this message. If 
you have received this message in error, please notify the author by replying 
to this message and then kindly delete the message. Thank you.