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.

inactivate sqldatabases in tsm

Discussion in 'Microsoft SQL Server' started by lvt, Dec 21, 2011.

  1. lvt

    lvt New Member

    Joined:
    May 27, 2004
    Messages:
    1
    Likes Received:
    0
    Occupation:
    tsm operator
    Location:
    odense, Denmark
    Hi

    I have a user, that create and delete a lot of databases on his SQL server, but the TDPSQL dosn't make the databases inactive when they no longer exist on the sql server. Did we missed something in our setup or in the dsm.opt file. We have to run selfmade script to get active database and to run inactivation against the TSM server.
    Anyone have a idea to cleanup in the sql data ?

    regards
    leif
     
  2.  
  3. zsoltesz

    zsoltesz New Member

    Joined:
    Feb 26, 2008
    Messages:
    107
    Likes Received:
    4
    Location:
    Hungary
    Hi,

    You have to inactivate manually via the tdpsql gui, or with the tdpsqlc.exe command.

    regards
    zoli
     

Share This Page