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.