Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

More flexible MSSQL backup / Pre-script for MSSQL backup

Created: 15 Feb 2013 | 3 comments
Symen's picture
1 Agree
0 Disagree
+1 1 Vote
Login to vote

Consider this situation:

  • X MSSQL servers
  • Y Instances per server
  • Z Databases per instance
  • N different backup schemes (full, differential, xlogs)
  • All instances contain a different set of databases

The current netbackup MSSQL agent doesn't support dynamically selecting all instances and dynamically selecting all databases at the same time. To back up this environment, the operator will probably create X policies. Possibly multiplied by N backup schemes. But then databases are still not selected dynamically. For dynamic db selection, the operator will have to create X * Y * N policies.

That's a lot

So my feature request is twofold:

Ideally: create a feature that will allow for backing up all schemes of all databases on all instances of all mssql server in one policy

Less-ideally, but also very useful: Allow for running pre-scripts (bpstart_notify) in MSSQL policies. This way the operator can create a script that dynamically generates the correct BCH before the backup starts.

Comments 3 CommentsJump to latest comment

Symen's picture

Is anyone else having this issue?

0
Login to vote
nathanmike's picture

@Syme,

Unfortunatly, i am facing the same problem and Netbackup does not support pre/post script for MS-SQL policy type:

http://www.symantec.com/docs/TECH34976

backup sripts for MS-SQL server are not so flexible and as you say, you need to manage Xpolicies, X.bch scripts ...

I hope there will be an enhancement for the future release ;-)

Nathan Mike

LPIC-1 and CLA-11

Symantec Registered Partner

nathan.mike@edotcom.be

www.edotcom.be&a

0
Login to vote
WY-Thinker's picture

I know this is possibly a bit late but you can select the databases dynamically by using the $ALL option in the BCH file 

OPERATION BACKUP
DATABASE $ALL
SQLHOST "SQLServer"
SQLINSTANCE "Instance"
NBSERVER "Netbackup server"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY policy
NUMBUFS 2
ENDOPER TRUE 

If there are database to not include in the backup, such as in a Transaction log backup .bch file where you would not want to backup databases in simple recovery model, you can add an exclusion for that  

OPERATION BACKUP
DATABASE $ALL
EXCLUDE databaseName
SQLHOST "SQLServer"
SQLINSTANCE "Instance"
NBSERVER "Netbackup server"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY policy
NUMBUFS 2
ENDOPER TRUE

Life; Don't talk to me about life

0
Login to vote