Exclude offline db's alone?

Asked and answered in this 'Related discussion':

https://vox.veritas.com/t5/NetBackup/how-to-exclude-sql-database-is-offline-state/m-p/837705/thread-id/229238

Thanks I exluded the Dbs using EXCLUDE option.

---

manha3560 wrote:

**** Moved to new discussion from : https://vox.veritas.com/t5/NetBackup/How-to-exclude-a-SQL-DB-of-a-particular-instance-from-backup/m-p/710124  ****

Is there any way to exclude offline db's alone?

---

Marianne wrote:

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.

---

 

---