Export (0) Print
Expand All

Select Backup Device

Use the Select Backup Device dialog box to select a logical backup device for the restore operation.

A logical backup device is a user-defined logical device that corresponds to a physical device, either a tape drive or a disk drive, that is provided by the operating system.

Note Note

If a backup uses multiple backup devices, they all must correspond to a single type of device.

To use SQL Server Management Studio to view the contents of a backup device

Backup device

In the list box, select the name of a logical backup device from which you want to restore.

For information about how to view the contents of a backup device, see View the Properties and Contents of a Logical Backup Device (SQL Server).

If you do not see a logical backup device that contains the backup you are seeking on the list, the backup might have been written directly to one or more files or tape drives. If this is the case, cancel the Select Backup Device dialog box; and in the Specify Backup dialog box, select File or Tape in the Backup media list box.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft