November 26, 2015 at 2:18 am
Guys,
I'm looking for a solution to restore a database with a different name (on another SQL-server) using SnapProtect -- DataOntap 3v6 / SnapProtect vs 10r2.
As a 'classical' DBA Im working in a mixed environment regarding backups taken from a range of SQL-servers.
A regular restore using SnapProtect is not that hard but yesterday I was asked to restore a database with a different name (and if possible on another servers).
Our NetApp specialist was not able to tell me how and I searched the internet for many hours and tried many options but none of the worked out !!!
Has anyone encountered this problem? and can someone tell me how to accomplish this (or point me to the appropriate documentation).
Please help me out ….
Regards
Guus Kramer
The Netherlands
November 26, 2015 at 2:23 am
As an alternative, could you restore it with the same name and then
exec sp_renamedb
?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 26, 2015 at 3:26 am
I cannot restore it with the same name on the same databaseserver and I'n not able to restore it to another server (not even with the initial name)!!
Guus
November 26, 2015 at 3:42 am
gkramer 23701 (11/26/2015)
I cannot restore it with the same name on the same databaseserver and I'n not able to restore it to another server (not even with the initial name)!!Guus
Hehe, I know nothing about this (feature-challenged?) product, so I'm going to leave this thread for someone who does.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 26, 2015 at 1:57 pm
gkramer 23701 (11/26/2015)
Guys,I'm looking for a solution to restore a database with a different name (on another SQL-server) using SnapProtect -- DataOntap 3v6 / SnapProtect vs 10r2.
As a 'classical' DBA Im working in a mixed environment regarding backups taken from a range of SQL-servers.
A regular restore using SnapProtect is not that hard but yesterday I was asked to restore a database with a different name (and if possible on another servers).
Our NetApp specialist was not able to tell me how and I searched the internet for many hours and tried many options but none of the worked out !!!
Has anyone encountered this problem? and can someone tell me how to accomplish this (or point me to the appropriate documentation).
Please help me out ….
Regards
Guus Kramer
The Netherlands
Have you consulted the documentation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2015 at 12:57 am
Perry,
The manual is just explaining a direct restore (restore/overwrite on the same server) and no other options!
(restore using a different name for the database or restore to another server (or the combination of the both)).......
Guus
November 30, 2015 at 5:41 am
Contact support?
I once tricked HP dataprotector by modifying the host-file of the HP backup server so dns calls would render the IP of target server instead of the Original server.
Target had also an HP client.
November 30, 2015 at 7:02 am
Have you tried modifying the host file on the server, spoofing the server names?
Create an entry on the application server, same name as destination server, but IP address to secondary? Maybe it will work?
Or create and alias on the client configuration tool? (cliconfig)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply