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

[felymich]

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

 

[felymich]

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

 

[felymich]

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