1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Excluding a Database?

Discussion in 'Microsoft SQL Server' started by Startx, Feb 1, 2012.

  1. Startx

    Startx New Member

    Joined:
    Feb 1, 2012
    Messages:
    5
    Likes Received:
    0
    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)
     
  2.  
  3. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,207
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    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.
     
  4. Startx

    Startx New Member

    Joined:
    Feb 1, 2012
    Messages:
    5
    Likes Received:
    0
    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
     
  5. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,207
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    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
     
  6. Startx

    Startx New Member

    Joined:
    Feb 1, 2012
    Messages:
    5
    Likes Received:
    0
    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
     
  7. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,207
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    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.
     
  8. zsoltesz

    zsoltesz New Member

    Joined:
    Feb 26, 2008
    Messages:
    107
    Likes Received:
    4
    Location:
    Hungary
    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*
     
  9. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    287
    Likes Received:
    26
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    Or, using the command line

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

    Startx New Member

    Joined:
    Feb 1, 2012
    Messages:
    5
    Likes Received:
    0
    @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!
     
: exclude, sql, tdp

Share This Page