Solved

Is DB2 Database restore to a SAN disk doable?

Posted on 2012-03-27
2
614 Views
Last Modified: 2012-06-21
Hi all,

I dn't believe this cannot be done but let me ask anyway. I am being told by our vendor support anlyst that and I quote "...DB restore on a SAN disk in not possible.
It’s not like any filesystem restore where you choose destination and restore the files irrespective of o/s flavors." unquote.

My question is this: If we have a separate SAN disk attached to a server, would it be possible to restore our database from HP Data Protector backup to the disk?

In the same vein as the first, We need to restore the database backup of ABCDEF into target database of GHIJKL on server any given server?

Please it would be helpful if someone has some experience with HP data protector and can confirm that restore from this software is possible or not...

Thanks
0
Comment
Question by:Enyinnaya
2 Comments
 
LVL 45

Accepted Solution

by:
Kdo earned 250 total points
ID: 37774181
Hi Enyinnaya,

The restore process doesn't care if the target device is SCSI, IDE, virtual, SAN, etc.  The I/O is through the logical device.

That said, I don't know much about your backup software.  It may have limitations that restrict your options, but I find in inconceivable that you can't restore the database to the same logical device from where it was backed up no matter what the underlying storage media is.


Kent
0
 
LVL 4

Assisted Solution

by:sathyaram_s
sathyaram_s earned 250 total points
ID: 37774206
If the backup is a snapshot backup, then you will have to clone the snapshot to be able to restore to another location. Without clone, the snapshot can be restored to the same location only.

If it is a "normal" backup, then there is no reason it cannot be resotred elsewhere.

Ask the vendor, whether snapshot is being used for backup ? and if it is, why you cannot clone and mount to a different location.

On a slightly different note,  some backup people don't understand that the database has to be suspended before taking a snapshot backup ... If you dont suspend, then you have a useless backup.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now