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.

TSM for SQL 5.5.2.0 Exclude offline Database

Discussion in 'TSM Client' started by interface, Nov 20, 2012.

Thread Status:
Not open for further replies.
  1. interface

    interface New Member

    Joined:
    Mar 23, 2011
    Messages:
    12
    Likes Received:
    0
    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.  
  3. zsoltesz

    zsoltesz New Member

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

    interface New Member

    Joined:
    Mar 23, 2011
    Messages:
    12
    Likes Received:
    0
    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
     
  5. zsoltesz

    zsoltesz New Member

    Joined:
    Feb 26, 2008
    Messages:
    107
    Likes Received:
    4
    Location:
    Hungary
    In the .opt file you can use the exclude/include statements. For exapmle, exlude \...\database_name\...\*

    Zoli
     
  6. interface

    interface New Member

    Joined:
    Mar 23, 2011
    Messages:
    12
    Likes Received:
    0
    Forgot to mention....

    I tried this :

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

    and this :

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

    Both no success.
     
  7. Trident

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    286
    Likes Received:
    26
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    You need to use tdpsqlc backup * full /excludedb=DBName
     
  8. interface

    interface New Member

    Joined:
    Mar 23, 2011
    Messages:
    12
    Likes Received:
    0
    Thnx for the reply Trident.

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

    Trident Senior Member

    Joined:
    Apr 2, 2007
    Messages:
    286
    Likes Received:
    26
    Occupation:
    IT operations
    Location:
    Oslo, Norway
    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.
     
  10. interface

    interface New Member

    Joined:
    Mar 23, 2011
    Messages:
    12
    Likes Received:
    0
    It's our old SQL server and there are just a few databases on it, so I used your suggestion and that worked. Thanks !
     
: sql
Thread Status:
Not open for further replies.

Share This Page