cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamically Changing SQL selections using BEMCLI?

BackupAdminHCC
Level 3

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.

Thanks.

1 REPLY 1

Keith----
Level 3

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.

Good luck,

Keith