08-05-2014 06:15 AM
Good day
I have a backup of the database MS SQL 2008/2012 possible to restore it to the usb hdd drive?
usb drive connected to the server Backup Exec.
.mdf and .ldf to get files ??
Solved! Go to Solution.
08-05-2014 08:45 PM
You did not indicate which version of BE you are using.
For BE 2012/2014, you can use the SQL copy function to get a copy of the backup and then use SQL Studio to restore the resultant .bak file to the remote server.
There is a similiar function in earlier versions of BE.
08-05-2014 08:39 AM
08-05-2014 09:22 AM
afaik, if you have backed up the DBs using the SQL agent, you would not be able to restore the .mdf and .ldf as flat-files. They have to be restored to a running SQL server .
08-05-2014 08:07 PM
good day
I have read the documentation c Recover MS sql. there about redirection indicated that this applies only to the instance, you can change the location of files.
in my situation it is necessary to restore a portable usb drive flat file database. can there is a workaround?
08-05-2014 08:22 PM
No. The .mdf and .ldf files are not backed up as flat files when you use the BE SQL agent and they are automatically excluded by AFE when you try to back them up as files.
Why do you need the flat files?
08-05-2014 08:35 PM
thanks for the answer. files needed to restore on a remote server which is located outside of my network.
08-05-2014 08:45 PM
You did not indicate which version of BE you are using.
For BE 2012/2014, you can use the SQL copy function to get a copy of the backup and then use SQL Studio to restore the resultant .bak file to the remote server.
There is a similiar function in earlier versions of BE.
08-05-2014 09:14 PM
install Backup Exec 2012 revision 1798 Service Pack 4.
thanks for the tip. but it's not exactly what I wanted to get it.
can I ask a question off topic: the use of SQL Agent for backups on sql server (.bak), BE reports an error that another application is already backed up and you need to run a full backup again. whether it is possible to combine the creation of something like the backed up copies of BE and SQL Agent (Jobs) ?