Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Exclude Specific SQL DBs by reccuring names

Created: 10 Feb 2014 • Updated: 10 Feb 2014 | 2 comments
EdafioJS's picture
This issue has been solved. See solution.

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?

 

Operating Systems:

Comments 2 CommentsJump to latest comment

EdafioJS's picture

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

 

 

SOLUTION
Laurie_Downey's picture

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)

Laurie Downey

Backup Exec

Advanced Tech Support

Symantec Corporation

www.symantec.com