Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL redirect restore of multiple mdf files.

Created: 14 Jun 2013 • Updated: 18 Jun 2013 | 4 comments
StefanosM's picture
This issue has been solved. See solution.

Hello,

I have been involved to an SQL restore and I 'm having a problem.

We need to restore an SQL database with 3 mdf files. All mdf files are located in the same drive. But we need to do the restore redirecting each mdf to a different drive.

We need to do that because we are restoring to vmware and the size of the three mdf files are exceeding the maximum size of the vmware datastore.

Is this possible with backup exec 2010 or not and how?

Thanks

Operating Systems:

Comments 4 CommentsJump to latest comment

pkh's picture

You cannot redirect the restore of individual .mdf files to different directories.

SOLUTION
StefanosM's picture

Thank you for the answer.

Jaydeep S's picture

@Stefanos, you could redirect restore the SQL database to a different SQL instance on a different server that has some space. However, you could do this 1 database at a time. Once the restore from Backup Exec is complete, go to SQL and detach the database. This would allow you to have the .mdf file ready to be moved to where ever you need to move it to.

StefanosM's picture

Jaydeep

What you suggest is not  possible using a VMware system for restore. There is a 2TB limit at VMware datastores and the database is more that 2TB.

EDIT:
As I understand, later, your suggestion is to restore to a physical server and then move the mdf files. This is the way we will go, but it is not the way we would like.

However, with netbackup is possible to redirect every mdf to a different location.