Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Sep 2002
    Location
    DK
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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. #2
    Senior Member
    Join Date
    Nov 2009
    Location
    India
    Posts
    315
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Any include/exlude statements being forced from TSM server?
    Tariq

  3. #3
    Member
    Join Date
    Sep 2002
    Location
    DK
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  4. #4
    Senior Member
    Join Date
    Nov 2009
    Location
    India
    Posts
    315
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    Try in this order.

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

  5. #5
    Member
    Join Date
    Sep 2002
    Location
    DK
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

  6. #6
    Senior Member
    Join Date
    Nov 2009
    Location
    India
    Posts
    315
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    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.
    Tariq

  7. #7
    Newcomer
    Join Date
    Feb 2012
    Location
    Italy
    Posts
    18
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default

    Same situation, with TDP SQL 5.5.5.1 and BA CLIENT 6.2.4.3.

    Is there any workaround or patch?

    thanks!

Similar Threads

  1. SQL TDP "Point in Time" Restore Issue
    By blizzard22 in forum Restore / Recovery Discussion
    Replies: 8
    Last Post: 08-19-2009, 04:51 PM
  2. "one-time conversion" warning when archiving
    By yorkshire-geordie in forum Backup / Archive Discussion
    Replies: 3
    Last Post: 07-17-2008, 09:22 AM
  3. TDP for sql "read only" file group backups
    By PENNYWISE in forum TDP/Application Layer Backup
    Replies: 0
    Last Post: 10-04-2007, 03:57 PM
  4. TDP for SQL: Backups changing DB recovery mode from "normal" to "simple"?
    By c.j.hund in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 09-12-2006, 04:29 AM
  5. Replies: 1
    Last Post: 12-14-2005, 10:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •