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.

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 New Member

    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 New Member

    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 New Member

    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