06-24-2021 02:45 AM
I was speaking to our SQL Manager this morning and he voiced a pain point he has using the SQL Scripts (I've tried to get them to switch to SQLi policies but to no avail).
His issue is having to exclude DBs from a backup. Is there a way to use a wild card for the EXCLUDE option?
Solved! Go to Solution.
06-24-2021 03:08 AM - edited 06-24-2021 03:12 AM
If I was the SQL admin:
I would write a script to discover the sql databases that I do not want to backup and populate (or recreate) the netbackup script with the correct lines for every database.
This script can be run manually or with windows scheduler every day, before the backup
06-24-2021 02:56 AM
I'm not aware there is a wildcard option for exclude option. My only thinking is move these DBs in a different instance and don't backup that instance.
06-24-2021 03:03 AM
Thanks Nic, unfortunately access to the DBs is outside of my control, I checked the SQL admin guide but didn't find anything so thought I'd ask the community.
06-24-2021 03:08 AM - edited 06-24-2021 03:12 AM
If I was the SQL admin:
I would write a script to discover the sql databases that I do not want to backup and populate (or recreate) the netbackup script with the correct lines for every database.
This script can be run manually or with windows scheduler every day, before the backup
06-24-2021 03:11 AM
Thanks for your input, I'll take this to the SQL manager then. The problem is, some of his DBAs follow the standard and some do not. But its the best I have to work with. Thank you.