Restore SQL Data base as a folder on different location with Backup Exec 2012
Created: 28 Jan 2013 | Updated: 02 Mar 2013 | 8 comments
This issue has been solved. See solution.
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
Discussion Filed Under:
Comments 8 Comments • Jump to latest comment
Hi,
Check pgs 732 & 634 of the Admin Guide.
Thanks!
If you find this is a solution, please mark it as such.
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.
---------------------------------------------
www.dotlike.net
How do you do a file restore when the .mdf and .ldf files are excluded from any backup by AFE?
@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.
@pkh -thank you so much for the information. Re-direction means I can redirect to some other machine with sql server installed in it???
Yes, as long as it has the RAWS agent installed.
Thanks!
If you find this is a solution, please mark it as such.
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.
Thank you much every one........ I am in the process of geting more information from Admin guide.
Thanks,
Shakeel
Would you like to reply?
Login or Register to post your comment.