1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

inactivate sqldatabases in tsm

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

  1. lvt

    lvt Newcomer

    Joined:
    May 27, 2004
    Messages:
    1
    Likes Received:
    0
    Occupation:
    tsm technican
    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 ADSM.ORG 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