EXCLUDE statement to exclude a table from backing up a database that has mulitple databases under

Backup Archive and Restore (BAR)
All things BAR
Enthusiast

EXCLUDE statement to exclude a table from backing up a database that has mulitple databases under

Esteemed listers,

 

TARA 16.10 on a Window server. TD 15.10.

 

I am trying to exclude a table 'DEF' from backing up all tables of the database 'ABC'.

The database ABC is under TRG_DATA and TRG_DATA has other databases.

What is the right syntax of the statement? Below EXCLUDE statement is one of the many statements that have failed.

Thank you,

 

ARCHIVE DATA TABLES

("DBC"),

("TRG_DATA") ALL,

 

(EXCLUDE TABLE ("ABC"."DEF")),

 

RELEASE LOCK, ... etc.

 

 


Accepted Solutions
Enthusiast

Re: EXCLUDE statement to exclude a table from backing up a database that has mulitple databases unde

I found the answer to my question. It's in bold.

 

ARCHIVE DATA TABLES

("DBC"),

(TRG_DATA) ALL (EXCLUDE TABLES (ABC.DEF)),

 

RELEASE LOCK, ... etc.

1 ACCEPTED SOLUTION
1 REPLY 1
Enthusiast

Re: EXCLUDE statement to exclude a table from backing up a database that has mulitple databases unde

I found the answer to my question. It's in bold.

 

ARCHIVE DATA TABLES

("DBC"),

(TRG_DATA) ALL (EXCLUDE TABLES (ABC.DEF)),

 

RELEASE LOCK, ... etc.