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.

The backup set holds a backup of a database other than the existing 'WSS_Content_Help

Discussion in 'TSM Operation' started by felymich, Dec 13, 2012.

  1. felymich

    felymich Active Newcomer

    Joined:
    Mar 7, 2012
    Messages:
    17
    Likes Received:
    0
    Hello,

    I am running:
    C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Content_HelpdeskProd Full
    /FROMSQLServer=MBSQLSPCL-ENT /INTO=WSS_Content_HelpdeskProd /TSMOPTFile=dsm_MBSQLSPCL.opt

    IBM Tivoli Storage Manager for Databases:
    But I am getting an error:
    The backup set holds a backup of a database other than the existing 'WSS_Content_HelpdeskProd' database.
    What is the option missing?

    Thnaks,
    DOm
     
  2.  
  3. felymich

    felymich Active Newcomer

    Joined:
    Mar 7, 2012
    Messages:
    17
    Likes Received:
    0
    Hello,

    by Adding /REPLACE I am getting another error:
    C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Content_HelpdeskProd Full
    /FROMSQLServer=MBSQLSPCL-ENT /INTO=WSS_Content_HelpdeskProd /TSMOPTFile=dsm_MBSQLSPCL.opt /REPLACE

    Exclusive access could not be obtained because the database is in use.

    Any idea?
    Thanks,
    Dom
     
  4. felymich

    felymich Active Newcomer

    Joined:
    Mar 7, 2012
    Messages:
    17
    Likes Received:
    0
    Hello,

    How to get the "Exclusive" access through TDPSQL Command line?
    The two SQL Servers are on version 10.0.2573 (identical).
    The account used is a Local Administrator on both servers.
    the account is a sysadmin on both SQL server/instances

    Thanks,
    Dom
     
    Last edited: Dec 13, 2012

Share This Page