Restore SQL Data base as a folder on different location with Backup Exec 2012

[shakeelmo]

Hi,

I was trying to restore SQL Data base as a folder on different location with Backup Exec 2012.

Please let me know; is it possible to restore to seperate locations. 

Looking forward for your response.

Thanks,

Shakeel

[CraigV]

Hi,

Check pgs 732 & 634 of the Admin Guide.

Thanks!

[dotlike]

you will have to do a file restore not a sql restore for to restore the database files to a different location. the wizard will give you the option to restore the files to another location.

[pkh]

How do you do a file restore when the .mdf and .ldf files are excluded from any backup by AFE?

[pkh]

@shakeel - When BE backs up a SQL database, it does not backup the .mdf/.ldf files.  It actually does a database dump and the .mdf/.ldf files are excluded from any backup by AFE.  So if you are just looking to restore the SQL databases, just like files, it cannot be done.

However, you can restore a SQL database with re-direction and direct the .mdf/,ldf files to be created by the restore to another directory.

[shakeelmo]

@pkh -thank you so much for the information. Re-direction means I can redirect to some other machine with sql server installed in it???

[CraigV]

Yes, as long as it has the RAWS agent installed.

Thanks!

[pkh · Accepted solution]

Take a look at the SQL chapter in the Admin Guide.  It will let you know the various re-direction parameters, including re-direction to another SQL instance whether it is on the same machine ot another machine.

[shakeelmo]

Thank you much every one........ I am in the process of geting  more information from Admin guide.

Thanks,

Shakeel