Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: View the Properties and Contents of a Logical Backup Device (SQL Server Management Studio)

This topic explains how to view the properties and content of a backup device.

  1. 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.

  2. Expand Server Objects, and expand Backup Devices.

  3. Click the device and right-click Properties, which opens the Backup Device dialog box.

  4. The General page displays the device name and destination, which is either a tape device or file path.

  5. In the Select a Page pane, click Media Contents.

  6. 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.
  7. The Backup sets grid displays information about the contents of the media set.

For more information, see Media Contents Page.

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

Community Additions

© 2015 Microsoft