I don't think there is any scripting capability on the MS-SQL agent.

Oracle policies launch plain shell scripts that allow you to decide
which NetBackup schedule to use, but MS-SQL bch files are simply a
list of parameters that get fed into the MS-SQL agent.

If I am wrong I would love to know how to implement the "decision
logic" in a MSSQL .bch file.

Austin Murphy


On 2/17/06, Bob Stump <stumpb AT michigan DOT gov> wrote:
>
> Is that the purpose of the "NBSCHED" which does not exist by default?
>
>
> >>> "Paul Keating" <pkeating AT bank-banque-canada DOT ca> 2/17/2006 2:15 PM 
> >>> >>>
> I haven't played with it a lot, but my understanding is that you have
> one script listed in the "backup selections", and you create multiple
> schedules, called full, diff, trans, etc.
>
> When the backup launches, the schedule name gets passed to the client as
> a parameter (argument) to the script.
>
> You write the script on the client to parse the schedule name, and run
> the appropriate backup job.
>
> Least that's what I got from my very superficial look at the topic.
>
> Paul
>
> > -----Original Message-----
> > From: veritas-bu-admin AT mailman.eng.auburn DOT edu
> > [mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
> > Bob Stump
> > Sent: February 17, 2006 2:09 PM
> > To: veritas-bu AT mailman.eng.auburn DOT edu; Bob Stump
> > Subject: Re: [Veritas-bu] sql server policies
> >
> >
> > I have gotten some responses on this question but I still
> > don't get it.
> >
> > I have automatically scheduled backups enabled for the MS-SQL server.
> > I have a policy named server-sql-full that runs a batchfile
> > called full.bch
> > I have another policy, server-sql-diff that runs a batchfile
> > called diff.bch
> > I have another policy, server-sql-trans that runs a batchfile
> > called trans.bch
> >
> > I would like to have a single policy that contains all 3 batchfiles
> > full.bch
> > diff.bch
> > trans.bch
> >
> > Can I do this by creating 4 schedules in one policy
> > sched-full
> > sched-diff
> > sched-trans
> > Default-Application-Backup
> > and listing all 3 batchfiles in the "Backup selections"?
> >
> >
> >
> > How can I keep the diff.bch from running when I want to run
> > the full.bch?
> > I understand that the schedule will want to run ALL
> > batchfiles listed in the "Backup Selections".
> > Is it possible to use an exclude_list to exclude diff.bch
> > from the sched-full schedule?
> >
> >
> >
> >
> > >>> "Bob Stump" <stumpb AT michigan DOT gov> 2/17/2006 8:45 AM >>>
> > I have been trying to figure out how to cut down the number
> > of policies for a MS-SQL server
> > I have one policy for a sql full which calls for the specific
> > batch file for fulls.
> > I have one policy for a sql diff which calls for the specific
> > batch file for incrementals
> > I have one policy for the transaction log which calls for the
> > specific batch file for the translog
> > I have one policy for the system level backup
> >
> > Is there some way I could combine the Full/Diff/Trans policies into 1?
> >
> >
> > _______________________________________________
> > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
> >
> > _______________________________________________
> > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
>
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>