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.

Exclude "\...\*" in tdp sql gives warning/fails

Discussion in 'Microsoft SQL Server' started by Geirr, Dec 5, 2011.

  1. Geirr

    Geirr New Member

    Joined:
    Sep 13, 2002
    Messages:
    27
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Location:
    DK
    Hi everyone

    I have a problem with TDP for SQL v. 5.5.5.1 (although same error in previous versions).

    I have a SQL 2005 server, with quite a few databases on it, and would like to be able to include only two databases, and exclude the rest.
    Incl/excl like this;

    EXCLUDE "\...\*"
    INCLUDE "\...\DB1\...\*"
    INCLUDE "\...\DB2\...\*"

    And then in my cmd file, use the command
    tdpsqlc backup * log ---blahblah

    When I do this, I get the following error (dsmerror.log for tdp), multiple times;
    ANS1115W File '' excluded by Include/Exclude list

    I have checked that the dsm.opt is correct (no funny characters, or runaway quotes etc), and that backups for the two wanted dbs finishes correct, but tsm reports schedule as failed. No other errors in dsmerror.log or windows event log.

    The point of doing it this way, instead of, say, naming databases on the commandline (in .cmd), or using the /EXCLUDEDB option, is to avoid having to correct this every time a new database is added to the server. It wouldn't be so big a problem, if there wasn't 60+ databases on the server, and I only want to backup a handful. (However both workarounds do work.)

    Has anyone seen this/corrected it? Any help will be much appreciated.

    Thanks
    Geirr G.
     
  2.  
  3. tariq.kaifi

    tariq.kaifi Member

    Joined:
    Nov 1, 2009
    Messages:
    316
    Likes Received:
    22
    Location:
    India
    Any include/exlude statements being forced from TSM server?
     
  4. Geirr

    Geirr New Member

    Joined:
    Sep 13, 2002
    Messages:
    27
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Location:
    DK
    Hi Tariq -
    no optionsets or excludes from serverside.
    I am thinking this could be a windows/mssql configuration issue, as there are som incl/excl in the OS (registry), that perhaps messes things up. (But I can't find it)
    G
     
  5. tariq.kaifi

    tariq.kaifi Member

    Joined:
    Nov 1, 2009
    Messages:
    316
    Likes Received:
    22
    Location:
    India
    Try in this order.

    INCLUDE "\...\DB1\...\*"
    INCLUDE "\...\DB2\...\*"
    EXCLUDE "\...\*"
     
  6. Geirr

    Geirr New Member

    Joined:
    Sep 13, 2002
    Messages:
    27
    Likes Received:
    0
    Occupation:
    TSM Administrator
    Location:
    DK
    Sorry, I've been out of the office tha last couple of days :)
    Tried that, and nothing is backed up, and the warnings still appears in the error log.

    I have had a PMR with IBM/Tivoli on this, and they suggest using one of the workarounds - looks like we are stuck with that. Oh well, it is not a disaster, just less automatic than we could hope.

    Thanks for your time Tariq - much appreciated. I just don't think we should spend more time on this, as it is more a small annoyance, rather than a serious bug/error.

    Regards
    G
     
  7. tariq.kaifi

    tariq.kaifi Member

    Joined:
    Nov 1, 2009
    Messages:
    316
    Likes Received:
    22
    Location:
    India
    I would like to hear IBM's say on this. Are they accepting it as a minor bug or something?

    And yes, please do post the workarounds.
     
  8. tvbe39

    tvbe39 New Member

    Joined:
    Feb 11, 2012
    Messages:
    18
    Likes Received:
    0
    Location:
    Italy
    Same situation, with TDP SQL 5.5.5.1 and BA CLIENT 6.2.4.3.

    Is there any workaround or patch?

    thanks!
     

Share This Page