cancel
Showing results for 
Search instead for 
Did you mean: 

Exclude Specific SQL DBs by reccuring names

EdafioJS
Level 3
Partner Accredited Certified

Related to Backup Exec 2012 SP3

I have a client with a large amount of SQL databases on a server we are backing up with Backup Exec.  The databases are all related to various customers, and each customer has two databases used for a specific function that does not need to be backed up (they rebuild these specific DB's daily).

The databases they do not need ot back up all have a common string of chracters in the name (ie. customer_TEMP for the DB name where TEMP is in each DB name that is not needed). I would like to set up global exclusions for the SQL databases they don;t want backed up, that way we don;t have to edit the backup selections each time a new clinet is brought on and a new "_TEMP" db is added. 

 

Is it possible to add the exclude for just the files that share that sepcific "_TEMP" identifier in the file name? Will this setting the global excludes apply t the SQL agent selections in the seleciton list?

 

1 ACCEPTED SOLUTION

Accepted Solutions

EdafioJS
Level 3
Partner Accredited Certified

I found the answer.  I added exclusions in the job selectioin list for the SQL instance, and used *_TEMP.* for the exclusion file name.

 

 

View solution in original post

2 REPLIES 2

EdafioJS
Level 3
Partner Accredited Certified

I found the answer.  I added exclusions in the job selectioin list for the SQL instance, and used *_TEMP.* for the exclusion file name.

 

 

Laurie_Downey
Level 6
Employee

For those who like formal documentation regarding the solution that EdiafioJS found you can refer to the following links.

Global Exclusions for Backup Exec 2012: 

http://www.symantec.com/docs/TECH186792

http://www.symantec.com/docs/HOWTO74341

(For previous versions of Backup Exec refer to http://www.symantec.com/docs/TECH29548)