.png)
View the Properties and Contents of a Logical Backup Device (SQL Server)
This topic describes how to view the properties and contents of a logical backup device in SQL Server 2012 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:
Security
For information about security, see RESTORE LABELONLY (Transact-SQL).
Permissions
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).
To view the properties and contents of a logical backup device
-
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
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
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.
Note
|
|---|
|
For more information, see Media Contents Page. |
To view the properties and contents of a logical backup device
-
Connect to the Database Engine.
-
From the Standard bar, click New Query.
-
Use the RESTORE LABELONLY statement. This example returns information about the AdvWrks2008R2Backup logical backup device.
USE AdventureWorks2012 ; RESTORE LABELONLY FROM AdvWrks2008R2Backup ; GO
