01-28-2013 12:43 AM
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
Solved! Go to Solution.
01-29-2013 05:24 PM
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.
01-28-2013 01:06 AM
Hi,
Check pgs 732 & 634 of the Admin Guide.
Thanks!
01-28-2013 05:00 AM
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.
01-28-2013 07:14 PM
How do you do a file restore when the .mdf and .ldf files are excluded from any backup by AFE?
01-28-2013 07:20 PM
@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.
01-29-2013 03:23 AM
@pkh -thank you so much for the information. Re-direction means I can redirect to some other machine with sql server installed in it???
01-29-2013 03:51 AM
Yes, as long as it has the RAWS agent installed.
Thanks!
01-29-2013 05:24 PM
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.
02-02-2013 01:12 AM
Thank you much every one........ I am in the process of geting more information from Admin guide.
Thanks,
Shakeel