Excluding a Database?

[Startx]

Hi all sorry for the Newb question,
I'm trying to exclude one database from the DSM.opt. I've read multiple tread on it and can't really figure out what's wrong in my DSM file.
Here's my syntax

EXCLUDE "mtlsql10\meta\...\Son_db\full*"
EXCLUDE "mtlsql10\data\...\Son_db\full*"
what am I missing?

Thank you for your time!
Don't forget I am a newbe for TSM. ;o)

 

[chad_small]

So the full backup always starts with full in the name? Also if we are talking about a windows sever you need to specify a drive.

EXCLUDE "*:\mtlsql10\meta\...\Son_db\full*"
EXCLUDE "*:\mtlsql10\data\...\Son_db\full*"

See if that works.

 

[Startx]

Thanks Chad, But it did not work.
Here is my full DSM

EXCLUDE "*:\mtlsql10\meta\...\Son_db\*"
EXCLUDE "*:\mtlsql10\data\...\Son_db\*"
INCLUDE "mtlsql10\meta\...\bud\full*" sql
INCLUDE "mtlsql10\data\...\bud\full*" sql
INCLUDE "mtlsql10\meta\...\arc2\full*" sql
INCLUDE "mtlsql10\data\...\arc2\full*" sql
INCLUDE "mtlsql10\meta\...\arc\full*" sql
INCLUDE "mtlsql10\data\...\arc\full*" sql
INCLUDE "mtlsql10\meta\...\User\full*" sql
INCLUDE "mtlsql10\data\...\User\full*" sql
INCLUDE "mtlsql10\meta\...\msdb\full*" sql
INCLUDE "mtlsql10\data\...\msdb\full*" sql
INCLUDE "mtlsql10\meta\...\model\full*" sql
INCLUDE "mtlsql10\data\...\model\full*" sql
INCLUDE "mtlsql10\meta\...\master\full*" sql
INCLUDE "mtlsql10\data\...\master\full*" sql

As for the DB that start with the name full, I really don't know. I will take a look at this with the DBA.
Thanks again

 

[chad_small]

EXCLUDEs need to be first in most INCLUDE/EXCLUDE lists. Remember this phrase...I used it when I taught TSM years ago to help students understand how INCLUDE/EXCLUDES work (I would have them repeat it out load, hence the ALL CAPS!)....

ANY EXCLUDE.DIR's ARE READ FIRST
BOTTOM UP PROCESSING
STOP WHEN YOU FIND A MATCH
IF ITS NOT EXCLUDED ITS INCLUDED!

Note: TSM starts reading from the BOTTOM of the list not top

 

[Startx]

I reverse the dsm so that it looks like this, and I still have the possibility to backup that database

INCLUDE "mtlsql10\meta\...\bud\full*" sql
INCLUDE "mtlsql10\data\...\bud\full*" sql
INCLUDE "mtlsql10\meta\...\arc2\full*" sql
INCLUDE "mtlsql10\data\...\arc2\full*" sql
INCLUDE "mtlsql10\meta\...\arc\full*" sql
INCLUDE "mtlsql10\data\...\arc\full*" sql
INCLUDE "mtlsql10\meta\...\User\full*" sql
INCLUDE "mtlsql10\data\...\User\full*" sql
INCLUDE "mtlsql10\meta\...\msdb\full*" sql
INCLUDE "mtlsql10\data\...\msdb\full*" sql
INCLUDE "mtlsql10\meta\...\model\full*" sql
INCLUDE "mtlsql10\data\...\model\full*" sql
INCLUDE "mtlsql10\meta\...\master\full*" sql
INCLUDE "mtlsql10\data\...\master\full*" sql
EXCLUDE "*:\mtlsql10\meta\...\Son_db\*"
EXCLUDE "*:\mtlsql10\data\...\Son_db\*"

Sorry for all the trouble

 

[chad_small]

No the Exclude will override any following includes for the same directory. The TSM client will exclude all files once it hits the mtlsql10\meta\...\Son_db\ and the \mtlsql10\data\...\Son_db\ directories. Any following includes will be ignored. Try it.

 

[zsoltesz]

I think, you use tdp for sql, not the ba client. In this case, you have to write something like this to the dsm.opt file:

exclude \...\Son_db\full*

 

[Trident]

Or, using the command line

tdpsqlc backup * full /excludedb=db1,db2,db3.....

 

[Startx]

@zsoltesz, yes I am using TDP. I've tried what you suggest but I'm still able to backup that database. I guess what I'll do is just stop my scheduler for tonight. It was only a one time deal and if I need further assistance I will place a call with IBM or come back to this forum where you get an excellent service!