Re: Issue restoring SQL database via TDP

[Paul_Dudley]

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"  wrote on 2017-10-31
23:07:56:

> From: Paul_Dudley 
> 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" 
>
> 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 
>
>
>
>
>
>
>
>
> 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.

Re: Issue restoring SQL database via TDP

[Andrew Raibeck]

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"  wrote on 2017-10-31
23:07:56:

> From: Paul_Dudley 
> 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" 
>
> 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 
>
>
>
>
>
>
>
>
> 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.
>