Hi Andy,
In the Windows client GUI there is no replace option. I selected the Restore to
Alternate location option.
Under that are the options:
Restore to original database
Restore to new database (select Instance and enter the database name)
Restore to original location
Restore files to all one directory (then you can browse and select the location
to restore to)
Relocate files individually (you can then edit the logical name, path & file
name if you want)
I chose to restore to a new database and relocate the files individually (and
modify the file name to restore over)
Thanks & Regards
Paul
-----Original
Message---------------------------------------------------------------------------------------------------
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: Wednesday, 1 November 2017 10:01 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Issue restoring SQL database via TDP
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.
>
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au
Click here to report this message as spam:
https://console.mailguard.com.au/ras/1RZwAMWfhL/3fwfdH5KeIFQWRSUPCCG5Q/0.5
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.
|