Video Screencast Help

Restore SQL to file?

Created: 03 Sep 2012 • Updated: 03 Sep 2012 | 2 comments
This issue has been solved. See solution.

is it possible to restore a database out in a file, instead of direct to another Sql server?

Comments 2 CommentsJump to latest comment

SuperBrain's picture

you can perform redirected restore and use "Use this path" option in the restore job properties (under redirected restore for SQL options)

That option will help you restore the database to a specific location on disk. To use this option, enter a drive letter and its corresponding path. For example, C:\temp. You can also click the ellipsis button and browse to a disk location. All paths entered are maintained in the Use this path drop-down list, which can be used for future redirected database restore jobs.

However, you cannot restore the .mdf .ldf files (as flat files)

Alternatively you can perform a redirect restore of SQL databases with new name on same server\instance and get .mdf and .ldf) - How to perform local and redirected restore of SQL 2000 & 2005 Databases with Backup Exec for Windows Servers (BEWS)
You can try this:
  1. In the new restore job, Select the database to restore
  2. Go to Microsoft SQL Redirection
  3. Enter the destination SQL server name (same or different)
  4. leave instance blank (if restoring to same one)
  5. Type in a new name for database to restore
  6. Start the restore job