Hi Poul Find "show restore options", there the replace is !
Med venlig hilsen / Best regards Leif Torstensen Backup Technician t: +45 70253030 | d: +45 63144019 e: l...@athena.dk | w: athena.dk Fyn: Munkerisvej 1 · 5230 Odense M · t: +45 70 25 30 30 Sjælland: Hørskætten 6A · 2630 Taastrup · t: +45 70 25 30 30 Jylland: Rådhuscentret 41 · 6500 Vojens · t: +45 70 25 30 30 -----Oprindelig meddelelse----- Fra: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] På vegne af Paul_Dudley Sendt: 1. november 2017 23:49 Til: ADSM-L@VM.MARIST.EDU Emne: Re: [ADSM-L] Issue restoring SQL database via TDP 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@VM.MARIST.EDU] On Behalf Of Andrew Raibeck Sent: Wednesday, 1 November 2017 10:01 PM To: ADSM-L@VM.MARIST.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 | stor...@us.ibm.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@VM.MARIST.EDU> wrote on 2017-10-31 23:07:56: > From: Paul_Dudley <pdud...@anl.com.au> > To: ADSM-L@VM.MARIST.EDU > Date: 2017-10-31 23:09 > Subject: Issue restoring SQL database via TDP Sent by: "ADSM: Dist > Stor Manager" <ADSM-L@VM.MARIST.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 > > pdud...@anl.com.au <mailto:pdud...@anl.com.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.
