ADSM-L

Re: scheduled SQL log backup question

2004-11-30 16:42:39
Subject: Re: scheduled SQL log backup question
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 30 Nov 2004 16:42:21 -0500
Luc, Steve, Joe,

Yes, this will work, and it will show up as an "excluded" database
in the statistics at the end. There is a similar requirement for
from some customers to remove a database from being "examined" at all.
Data Protection will examine (get status and other details) all databases,
even the ones that are EXCLUDEd in the DSM.OPT file. For example, if there

is a database known to be "down or in standbye" state, it will show up as
an error,
even if it EXCLUDEd. The similar requirement is to allow a way to bypass
even those databases.

The EXCLUDE statements will work for this particular case.
I am sorry if I misinterpreted the question.

Thanks for clearing this up Joe and Steve.

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/30/2004
03:50:44 PM:

> After I sent my last post I remembered this (from dsm.smp)
>
>
> *======================================================================*
> * The following include statements assign all meta objects to          *
> * management class SqlDbMetaMgmtClass and all data objects to          *
> * SqlDbDataMgmtClass                                                   *
>
> *======================================================================*
>
> *INCLUDE "\...\meta\...\*"     SqlDbMetaMgmtClass
> *INCLUDE "\...\data\...\*"     SqlDbDataMgmtClass
>
> *======================================================================*
> * The following include statements assign all log meta objects to      *
> * management class SqlLogMetaMgmtClass and all log data objects to     *
> * SqlLogDataMgmtClass                                                  *
>
> *======================================================================*
>
> *INCLUDE "\...\meta\...\log*"  SqlLogMetaMgmtClass
> *INCLUDE "\...\data\...\log*"  SqlLogDataMgmtClass
>
> *======================================================================*
> * The following exclude statements exclude all log backups for         *
> * databases master and msdb                                            *
> *======================================================================*
>
> *EXCLUDE "\...\master\...\log*"
> *EXCLUDE "\...\msdb\...\log*"
>
>
>
>
> Del,
> can you comment this. You said that we cannot exclude databases in this
> release. I never used it, but I think this is what Luc is looking for;
> to exclude log backup of master db.
>
>
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax:     416-235-0265
> Web: www.infinitynetwork.com
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Del Hoobler
> Sent: Tuesday, November 30, 2004 1:55 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: scheduled SQL log backup question
>
> Luc,
>
> This is a known requirement that has been submitted and being
> prioritized for a future release, i.e. allowing you to
> "exclude" certain databases from a command.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/30/2004
> 01:47:30 PM:
>
> > Thanks Joe .....
> >
> > I thought of that one but I was hopping for a nice exetp option ...
> > cool .. I will do that way...
> >
> > thanks again
> >
> > Luc
> >
> >
> >
> >
> >
> > Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > 2004-11-30 01:35 PM
> > Please respond to "ADSM: Dist Stor Manager"
> >
> >
> >         To:     ADSM-L AT VM.MARIST DOT EDU
> >         cc:
> >         Subject:        Re: scheduled SQL log backup question
> >
> >
> > I think you cannot take log backup of master db; only full; that
> doesn't
> > matter, it is small database (but very important)
> >
> > In your script put "tdpsqlc backup db1,db2,db3,db4 log ....."
> >
> > Db1,db2... are database names (don't include master)
> >
> > Joe Crnjanski - Partner
> > Infinity Network Solutions Inc.
> > Phone: 416-235-0931 x26
> > Fax:     416-235-0265
> > Web: www.infinitynetwork.com
> >
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> > Luc Beaudoin
> > Sent: Tuesday, November 30, 2004 11:56 AM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: scheduled SQL log backup question
> >
> > Hi all
> >
> > I'm doing SQL LOG backup every 6 hours and a full backup every day ...
> >
> > I got a failed status everytime cause I can not take theLOG backup of
> > the
> > master DB ...
> >
> > This is the command that I launch ...
> >
> > %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
> > /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
> >
> > Is there a option that I can put .. like   backup ALL LOG except
> MASTER
> >
> > thanks
> >
> > Luc Beaudoin
> > Network Administrator/ SAN/TSM
> > Hopital General Juif S.M.B.D.
> > Tel: (514) 340-8222 ext:8254

<Prev in Thread] Current Thread [Next in Thread>