Exclude offline db's alone?

[manha3560]

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

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.

---

[Marianne]

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-...

[manha3560]

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-...  ****

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.

---

---

[shishupal123456]

i Have tested it , It's worked 

Thanks 

[shishupal123456]

Hi I have tested the SQL excluding DB into script , and found it worked .

Thanks for KT ...