Oh, that explains it.
Thank you, Bertaut!
--
Warm regards,
Michael Green
On Wed, Jul 29, 2009 at 6:06 PM, Tchuise,
Bertaut<BTchuise AT lmus.leggmason DOT com> wrote:
> 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.
>
|