Hi Paul, did you use the REPLACE option?

Regards,

Andy

____________________________________________________________________________

Andrew Raibeck | IBM Spectrum Protect Level 3 | storman AT us.ibm DOT com

IBM Tivoli Storage Manager links:
Product support:
https://www.ibm.com/support/entry/portal/product/tivoli/tivoli_storage_manager

Online documentation:
http://www.ibm.com/support/knowledgecenter/SSGSG7/landing/welcome_ssgsg7.html

Product Wiki:
https://www.ibm.com/developerworks/community/wikis/home/wiki/Tivoli%20Storage%20Manager

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2017-10-31
23:07:56:

> From: Paul_Dudley <pdudley AT ANL.COM DOT AU>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 2017-10-31 23:09
> Subject: Issue restoring SQL database via TDP
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> I was trying to restore an SQL database from one server (production)
> to another server (test) and over the top of a database with a different
name.
>
>
>
> On the production server the database is called
> "InterfaceLoggingProduction". On the test server the database I was
> trying to restore over the top of is called
"InterfaceLoggingProdHoldRestore".
>
> The databases are backed up using Legacy, not VSS. I was using the
> TDP for SQL client on a Windows server to perform the restore. I
> selected the options to manually enter the new database name, and to
> select the locations of the database and log files. The error I kept
> running into was:
>
>
>
> An exception occurred while executing a Transact-SQL statement or batch.
>
> The backup set holds a backup of a database other than the existing
> 'InterfaceLoggingProdHoldRestore' database.
>
> RESTORE DATABASE is terminating abnormally.
>
> In the end I had to restore the database from the production server
> to the test server and use the same database name. Is it not
> possible to restore over the top of a different named database?
>
>
>
> Regards
>
> Paul Dudley
>
> pdudley AT anl.com DOT au <mailto:pdudley AT anl.com DOT au>
>
>
>
>
>
>
>
>
> ANL DISCLAIMER
>
> This e-mail and any file attached is confidential, and intended
> solely to the named add
> ressees. Any unauthorised dissemination or use is strictly
> prohibited. If you received
> this e-mail in error, please immediately notify the sender by return
> e-mail from your s
> ystem. Please do not copy, use or make reference to it for any
> purpose, or disclose its
>  contents to any person.
>