Skip to content

Latest commit

 

History

History
102 lines (68 loc) · 4.75 KB

view-the-properties-and-contents-of-a-logical-backup-device-sql-server.md

File metadata and controls

102 lines (68 loc) · 4.75 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
View logical backup device contents
Learn how to view the properties and contents of a logical backup device in SQL Server by using SQL Server Management Studio or Transact-SQL.
MashaMSFT
mathoma
03/15/2017
sql
backup-restore
how-to
displaying backup content
viewing backup content
database backups [SQL Server], viewing content
backing up databases [SQL Server], viewing content
backing up databases [SQL Server], properties
displaying backup properties
backup devices [SQL Server], viewing information
viewing backup properties
database backups [SQL Server], properties

View the Properties and Contents of a Logical Backup Device (SQL Server)

[!INCLUDE SQL Server]

This topic describes how to view the properties and contents of a logical backup device in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Security

For information about security, see RESTORE LABELONLY (Transact-SQL).

Permissions

In [!INCLUDEsql2008-md] 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).

Using SQL Server Management Studio

To view the properties and contents of a logical backup device

  1. After connecting to the appropriate instance of the [!INCLUDEmsCoName] [!INCLUDEssDEnoversion], 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.

Note

For more information, see Media Contents Page.

Using Transact-SQL

To view the properties and contents of a logical backup device

  1. Connect to the [!INCLUDEssDE].

  2. From the Standard bar, click New Query.

  3. Use the RESTORE LABELONLY statement. This example returns information about the AdvWrks2008R2Backup logical backup device.

USE AdventureWorks2022;  
RESTORE LABELONLY  
   FROM AdvWrks2008R2Backup ;  
GO

See Also

backupfilegroup (Transact-SQL)
backupfile (Transact-SQL)
backupset (Transact-SQL)
backupmediaset (Transact-SQL)
backupmediafamily (Transact-SQL)
sp_addumpdevice (Transact-SQL)
Backup Devices (SQL Server)