Export (0) Print
Expand All

Select Backup Device


Applies To: SQL Server 2016

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.

System_CAPS_ICON_note.jpg 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.

Backup Devices (SQL Server)

Community Additions

© 2016 Microsoft