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. >
