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 ther...
7.6
Agent for Microsoft SQL Server
Backing Up
Backup and Recovery
Linux
NetBackup
  • RamNagalla's avatar
    RamNagalla
    10 years ago

    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.

RamNagalla's avatar
RamNagalla
Moderator
10 years ago

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.