Re: [ADSM-L] TDP MSSQL excludes
2009-07-29 11:08:45
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.
|
|
|