View the Properties and Contents of a Logical Backup Device (SQL Server)
Applies To: SQL Server 2016
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
This topic describes how to view the properties and contents of a logical backup device in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To view the properties and contents of a logical backup device, using:
For information about security, see RESTORE LABELONLY (Transact-SQL).
In SQL Server 2008 and later versions, obtaining information about a backup set or backup device requires CREATE DATABASE permission. For more information, see GRANT Database Permissions (Transact-SQL).
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
Expand Server Objects, and expand Backup Devices.
Click the device and right-click Properties, which opens the Backup Device dialog box.
The General page displays the device name and destination, which is either a tape device or file path.
In the Select a Page pane, click Media Contents.
The right-hand pane displays in the following properties panels:
Media sequence information (the media sequence number, the family sequence number, and the mirror identifier, if any) and the media creation date and time.
Media set information: the media set name and description, if any, and the number of families in the media set.
The Backup sets grid displays information about the contents of the media set.
Connect to the Database Engine.
From the Standard bar, click New Query.
Use the RESTORE LABELONLY statement. This example returns information about the
AdvWrks2008R2Backuplogical backup device.