Backup exec redirect sql restore to file

Ratings: 5 6. Product s : Backup Exec. Verify the storage location tape, disk, deduplication store, etc has the backup set needed for restore. Select the SQl Instance the database resides on, then select the database to restore.

Select the database time or transacation log to restore the database to. Select if the database will be restored to the original location or redirected. Select how to the database is restored. Select the consistency check option to use for the restore.

Select the recovery state for the databases. Select any additional options needed for the restore. This list contains only databases that have been backed up according to the msdb backup history.

Click the browse button. In the Specify backup devices dialog box, select one of the listed device types in the Backup media type list box. To select one or more devices for the Backup media list box, click Add. After you add the devices you want to the Backup media list box, click OK to return to the General page. In the Select the backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location.

By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Any backups that depend on a deselected backup are deselected automatically. In the Restore database files as grid, specify a new location for the file or files that you want to move. The transaction log backups, if applied, must cover the time when the files and filegroups were backed up.

This example restores two of the files for the MyNwind database that were originally located on Drive C to new locations on Drive D. Two transaction logs will also be applied to restore the database to the current time. Skip to main content. Improve this question. Maybe this can help you: stackoverflow. Add a comment. Active Oldest Votes. Improve this answer. AlexR AlexR k 14 14 gold badges silver badges bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.