Re: [Veritas-bu] Schedule SQL Log backup in Netbackup
2009-02-05 15:32:38
Hi Ed,
I think there is a confusion here, probably,
i did not explain it clearly my requirement.
Ok, Here it is:
Actually we are implementing the Netbackup
SQL Agent for all our SQL databases. So iam finding the best method to
implement the Full, Diff & tlog backup.
Full - Needs to run weekends
Diff. - Needs to Run week days
TLog - Needs to run every 15 minutes
This is the requirement.
But in the past these SQL backup were
managed by the SQL dba's uning the SQL scheduler in .bak extension, &
disk as the target of backup. So Our SQL DBA were telling that when FULL
or Diff SQL backup is running they will disable the TLog backup, untill
the Full or Diff backup is completed.
So we are also planning to implement
the same method as suggested by them, using the Netbackup SQL Agent
Pls. recommend if there is any better
method to implement using the Netbackup SQL Agent.
Regards,
Ed Wilts <ewilts AT ewilts DOT org>
02/05/2009 12:02 PM
|
To
| Suresh_Natarajan AT toyota DOT com
|
cc
| veritas-bu AT mailman.eng.auburn DOT edu
|
Subject
| Re: [Veritas-bu] Schedule SQL Log backup
in Netbackup |
|
On Thu, Feb 5, 2009 at 1:19 PM, <Suresh_Natarajan AT toyota DOT com>
wrote:
We are in the process of setting up the SQL Hotbackup agent policies using
Netbackup. We are looking for a method to do the below:
1. When a Full or Differential SQL backup is starting & till the jobs
completes, we want SQL log Netbackup policy to be disabled.? How
do i do this? the below is the order i want to do it.
a) When a Full backup or diff. is started from the Netbackup policy.,
First step: deactivate/disable the SQL Log policy in netbackup
Second. step : Run the full or diff backup
Third step: once the jobs is completed , then activate/enable the
SQL Log policy in netbackup
I really don't think you want to do this - the process looks error prone
and I expect that if you go down this route you'll find yourself with disabled
backup policies when they should be enabled. To make matters worse,
it will be your sql log policies which means you won't be able to restore
if anything does go wrong and I really do expect that you'll not realize
it until after you need to do a restore and it's too late.
Use a NetBackup SQL agent and put it in control.
.../Ed
Ed Wilts, RHCE, BCFP, BCSD, SCSP, SCSE
ewilts AT ewilts DOT org
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|