1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

Excluding a Database?

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

  1. Startx

    Startx Active Newcomer

    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 ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    46
    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 Active Newcomer

    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 ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    46
    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 Active Newcomer

    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 ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    46
    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 ADSM.ORG 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 ADSM.ORG Senior Member

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

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

    Startx Active Newcomer

    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