Forum Discussion

Ajeesh's avatar
Ajeesh
Level 3
10 years ago

How to exclude a SQL DB of a particular instance from backup

Hi,

I am using separate scripts to perform FULL, INCR & LOG backups of the MSSQL databases. In each of the scripts I use the keyword "SQLINSTANCE $ALL" to backup all the instances.

Suppose there are 3 instances: Instance1, Instance2, Instance3. And all these instances have 1 database named "DB01".

Now, I need to exclude the database DB01 from LOG backup script of instance "Instance1". But the databases of Instance2 and Instance3 shouldn't be excluded.

Note: I already heard about excluding the databases using NB_SQL_DATABASE_EXCLUDE environment variable. But this will cause excluding the database from all 3 instances. But what I want to exclude is only "Instance1\DB01".

 

Regards,

Ajeesh B

 

  • since you have the same database name in the 3 instances...

    you need to use the 3 seperate scripts for each instance.. and use Keyword EXCLUDE  in the script that you would like to exclude the DB01.

    eiter you can go with the unique DB naming stardard across the host to make use of NB_SQL_DATABASE_EXCLUDE or EXCLUDE with single script.

  • go to Host Properties

    Clients

    Properties

    Exclude list

    Give the path

     

    exclude.JPG

  • since you have the same database name in the 3 instances...

    you need to use the 3 seperate scripts for each instance.. and use Keyword EXCLUDE  in the script that you would like to exclude the DB01.

    eiter you can go with the unique DB naming stardard across the host to make use of NB_SQL_DATABASE_EXCLUDE or EXCLUDE with single script.

  • @Inn_Kam.. Thanks. I am looking for excluding MSSQL database, not any folder/file.

     

    @Ramnagalla... Thank you. I am aware of this method. But I do not want to use this method of creating one scripts for each instance as I have multiple instance, not just 3. Is there any other parameter/options in Netbackup that help me exclude a Database that is specific to an instance - as I mentioned in my post.

  • Ajeesh,

    unfortunatly i dont find any other way .... there may be something, but i am not finding it now.. 

    having the naming Standards to keep the unique names for each DB would have make your life easier... 

  • NO!!! Filesystem exclude list will NOT work for a database backup!!!!

  • Have a look at this TN:
    Keywords and values used in batch files: http://www.symantec.com/docs/HOWTO85316 

    My suggestion is to specify each Instance separately followed by DATABASE $all and then add EXCLUDE DB01 in the relevant Instance section.

    e.g.

    SQLINSTANCE Instance1
    OPERATION BACKUP
    DATABASE $ALL 
    EXCLUDE DB01
    NBSERVER ....
    ...
    ENDOPER TRUE
    
    SQLINSTANCE Instance2
    OPERATION BACKUP
    DATABASE $ALL 
    NBSERVER ...

     

    I have not tried this, but I guess worth a try?
    Or else separate scripts for each Instance as per above suggestion.