More flexible MSSQL backup / Pre-script for MSSQL backup
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.