We have configured a Maintenance Plan with the "Back Up Database Task" for all databases. This ensures that backups are automatically set up for newly created databases.
Now, we want to enable backup encryption for specific databases. How can we achieve this while maintaining the option to backup newly created databases?
BR
Probably time to do a little coding.
I'd maintain an exclusion table somewhere so that you can list the databases that you do NOT want to backup. Then use that in the code that selects the list of databases to be backed up.
If you're using the wizards in SSMS for this, they just are not that flexible.
You have to do it yourself or look to external tool such as Ola Hallengren's scripts (easy search online) that include such functionality. – Grant Fritchey
