02-11-2020 08:15 AM
Using BEMCLI, is it possible to dynamically change the backup selections for SQL databases? Since BE does not currently support AlwaysOn Availability Groups natively, I was thinking of the possibility of having a Pre Job Script that would enumerate all of the instances/DBs that are primary on the current node and change the BE selection based on that script to automate the backups.
02-20-2020 12:39 PM
The Set-BEBackupDefinition command can be used in the BEMCLI to modify backup definitions. An alternative to using the Pre Job Script to modify the backup definition after the job has already started, is to schedule the BEMCLI script using Windows Task Scheduler.