Steve,

Yes.. these are the same thing. The requirement addresses
the fact that you know some databases will be offline or
in some other state and lets you tell DP/SQL to skip them.
If you don't tell us to skip them, we report them as an error
because it is something you should know about...
... i.e. that it did not get backed up for some reason.
That is the reason the requirement was opened.

Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/11/2005
01:28:33 PM:

> Del,
> Here is a snip of the dsm.opt and log, but after traveling through other
> logs, I also seem some default instances with the same errors, so I am
> assuming offline databases fall under the same category you referenced
> earlier.  The issue is that the schedule is showing up on the TOR as
> being failed, and our operations staff is spending time tracking down
> bogus problems.
> -steve
>
> Date/Time             Message
>
> --------------------
> ----------------------------------------------------------
> 11/11/05 02:56:31     ANR2579E Schedule SQL_MONGO in domain NT_SERVERS
> for node
>                         MONGO_SQL failed (return code 402). (SESSION:
> 169701)
>
> *======================================================================*
> * The following statements exclude offline databases                   *
> *======================================================================*
> EXCLUDE "\...\IS_Security\...\*"
> EXCLUDE "\...\NSO\...\*"
> EXCLUDE "\...\test_dr\...\*"
> EXCLUDE "\...\UserAuthenticationTest\...\*"
> EXCLUDE "\...\ReportServer_Beta\...\*"
> EXCLUDE "\...\ReportServer_BetaTempDB\...\*"
> EXCLUDE "\...\EPECdb\...\*"
> EXCLUDE "\...\EPERdb\...\*"
> EXCLUDE "\...\ipd_conv\...\*"
> EXCLUDE "\...\ipd_test_conv\...\*"
>
> 11/10/2005 21:40:51 Request                       : FULL BACKUP
> 11/10/2005 21:40:51 Database Input List           : *
> 11/10/2005 21:40:51 Group Input List              : -
> 11/10/2005 21:40:51 File Input List               : -
> 11/10/2005 21:40:51 Number of Buffers             : 4
> 11/10/2005 21:40:51 Buffer Size                   : 8192
> 11/10/2005 21:40:51 Number of SQL Buffers         : 0
> 11/10/2005 21:40:51 SQL Buffer Size               : 1024
> 11/10/2005 21:40:51 Number of Stripes specified   : 4
> 11/10/2005 21:40:51 Estimate                      : -
> 11/10/2005 21:40:51 Truncate Log?                 : -
> 11/10/2005 21:40:51 Wait for Tape Mounts?         : Yes
> 11/10/2005 21:40:51 TSM Options File              : C:\Program
> Files\Tivoli\TSM\TDPSql\dsm.opt
> 11/10/2005 21:40:51 TSM Nodename Override         : -
> 11/10/2005 21:40:52 Sqlserver                     : MONGO\MONGOOSE
> 11/10/2005 21:40:52
> 11/10/2005 21:41:27 Backup of SQL Database EPECdb will not be attempted.
> 11/10/2005 21:41:27 SQL Database Status: StatusError768
> 11/10/2005 21:41:27 ACO5422E Received the following from the MS SQL
> server:
> 11/10/2005 21:41:27 [Microsoft][ODBC SQL Server Driver][SQL
> Server]Database 'EPECdb' cannot be opened because it is offline.
> Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x800403ae)
> 11/10/2005 21:41:27 Backup of SQL Database EPERdb will not be attempted.
> 11/10/2005 21:41:27 SQL Database Status: StatusError768
> 11/10/2005 21:41:27 ACO5422E Received the following from the MS SQL
> server:
> 11/10/2005 21:41:27 [Microsoft][ODBC SQL Server Driver][SQL
> Server]Database 'EPERdb' cannot be opened because it is offline.
> Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x800403ae)
> 11/10/2005 21:41:27 Backup of SQL Database ipd_conv will not be
> attempted.
> 11/10/2005 21:41:27 SQL Database Status: StatusError768
> 11/10/2005 21:41:27 ACO5422E Received the following from the MS SQL
> server:
> 11/10/2005 21:41:27 [Microsoft][ODBC SQL Server Driver][SQL
> Server]Database 'ipd_conv' cannot be opened because it is offline.
> Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x800403ae)
> 11/11/2005 02:56:30 Total SQL backups selected:               161
> 11/11/2005 02:56:30 Total SQL backups attempted:              157
> 11/11/2005 02:56:30 Total SQL backups completed:              157
> 11/11/2005 02:56:30 Total SQL backups excluded:               1
> 11/11/2005 02:56:30 Total SQL backups inactivated:            0
> 11/11/2005 02:56:30 Throughput rate:                          23,902.35
> Kb/Sec
> 11/11/2005 02:56:30 Total bytes transferred:
> 461,937,526,168
> 11/11/2005 02:56:30 Elapsed processing time:                  18,873.07
> Secs
> 11/11/2005 02:56:30 ACO0151E Errors occurred while processing the
> request.
> 11/11/2005 02:56:30 ACO0151E Errors occurred while processing the
> request.
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Del Hoobler
> Sent: Friday, November 11, 2005 11:44 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] TDP for SQL exclude not working
>
> Steve,
>
> Can you be more specific on what you mean?
> Something like:
>    EXCLUDE "\...\db1\...\*"
> Should exclude the "db1" database for whatever instance you are backing
> up.
> If you want to specify a certain instance in an exclude statement, you
> can do that too. I will refer you to the DP/SQL User's Guide:
>      "Appendix C. Advanced procedures"
>          - Sample include/exclude statements It discusses this and gives
> very specific details and examples.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/11/2005
> 08:51:17 AM:
>
> > Thanks, Del.
> > Does this also explain why I am having trouble excluding non-default
> > instance databases, or do I need to add something to my exclude
> > statement for those?
> > -steve