Restore MSSQL database to USB hdd driver

[MaximusK]

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 ??

[pkh]

Yes. You can redirect the restore to any volume/path that you want.

[VJware]

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 .

[MaximusK]

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?

[pkh]

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?

[MaximusK]

thanks for the answer. files needed to restore on a remote server which is located outside of my network.

[pkh · Accepted solution]

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.

[MaximusK]

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) ?