Forum Discussion

L_BR's avatar
L_BR
Level 5
4 years ago

Wildcards for SQL Batch Script

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 exc...
8.2
Windows Server 2016
  • StefanosM's avatar
    StefanosM
    4 years ago

    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

     

Nick_Morris's avatar
Nick_Morris
Level 6

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.

L_BR's avatar
L_BR
Level 5
4 years ago

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.

  • StefanosM's avatar
    StefanosM
    Level 6
    4 years ago

    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

     

    • L_BR's avatar
      L_BR
      Level 5
      4 years ago

      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.