Results 1 to 9 of 9
  1. #1
    Newcomer
    Join Date
    Mar 2011
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default TSM for SQL 5.5.2.0 Exclude offline Database

    Hi guys,

    I'm having a problem with backing up my SQL databases. I turned 1 database offline and now it keeps giving errors ( return code 402 ). It's a Windows 2000 machine ( I know it's old ) with the 5.5.2.0 Client installed on it.

    Does anyone know how to exclude a offline database through the OPT-file ?

    Thanks in advance.

  2. #2
    Member zsoltesz's Avatar
    Join Date
    Feb 2008
    Location
    Hungary
    Posts
    104
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    Hi,

    I think, you use the command like this: tdpsqlc backup * full ....

    In the syntax of the tdpsqlc command there is e new parameter: /excludedb. Using this paramater you can exclude the offile database from the backup.

    Zoli

  3. #3
    Newcomer
    Join Date
    Mar 2011
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hi Zoli,

    I found that command, but in that case I need to set every database in the tdpsqlc command. I prefer to set it in the OPT file like : tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt

  4. #4
    Member zsoltesz's Avatar
    Join Date
    Feb 2008
    Location
    Hungary
    Posts
    104
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    In the .opt file you can use the exclude/include statements. For exapmle, exlude \...\database_name\...\*

    Zoli

  5. #5
    Newcomer
    Join Date
    Mar 2011
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Forgot to mention....

    I tried this :

    EXCLUDE \...\CREFO\...\*

    and this :

    EXCLUDE \...\meta\...\CREFO\...\*

    Both no success.

  6. #6
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    270
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    You need to use tdpsqlc backup * full /excludedb=DBName
    -= Trident =-

  7. #7
    Newcomer
    Join Date
    Mar 2011
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thnx for the reply Trident.

    Now I get another failure : "ANR2579E - Return Code 1204" so that is not working....

  8. #8
    Senior Member Trident's Avatar
    Join Date
    Apr 2007
    Location
    Oslo, Norway
    Posts
    270
    Thanks
    2
    Thanked 19 Times in 19 Posts

    Default

    I think your are stuck between a rock and a mountain. excludedb came on a later release.

    If your number of db's are low, then

    tdpsqlc backup db1,db2...dbX full

    is probably the only choice, unless you can upgrade your client.
    -= Trident =-

  9. #9
    Newcomer
    Join Date
    Mar 2011
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    It's our old SQL server and there are just a few databases on it, so I used your suggestion and that worked. Thanks !

Similar Threads

  1. Exclude offline MSSQL databases automatically?
    By EvertM in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 11-25-2008, 10:50 AM
  2. How to exclude suspect and offline SQL databases
    By spiffy in forum TDP/Application Layer Backup
    Replies: 5
    Last Post: 08-26-2008, 12:42 PM
  3. TDP for SQL offline Database Exclusion - How to?!
    By Swanny in forum TDP/Application Layer Backup
    Replies: 3
    Last Post: 03-28-2007, 01:19 AM
  4. Replies: 5
    Last Post: 05-21-2006, 04:13 PM
  5. Exclude an offline SQL database
    By JCzub in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 02-12-2004, 09:41 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
  •