Skip to content

view-the-data-and-log-files-in-a-backup-set-sql-server.md

Latest commit

 

History

History
82 lines (56 loc) · 3.92 KB

view-the-data-and-log-files-in-a-backup-set-sql-server.md

File metadata and controls

82 lines (56 loc) · 3.92 KB
title View backup set data & Log files
description Learn how to view the data and log files in a backup set in SQL Server by using SQL Server Management Studio or Transact-SQL.
author MashaMSFT
ms.author mathoma
ms.date 12/17/2019
ms.service sql
ms.subservice backup-restore
ms.topic how-to
helpviewer_keywords
database backups [SQL Server], viewing backup sets
viewing backup set information
backup sets [SQL Server], viewing files in
displaying backup set information
transaction log backups [SQL Server], viewing backup sets
backing up [SQL Server], viewing backup sets

View the data and log files in a backup set (SQL Server)

[!INCLUDE SQL Server]

This topic describes how to view the data and log files in a backup set in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Security

For information about security, see RESTORE FILELISTONLY (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 data and log files in a backup set

  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 Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.

  3. Right-click the database, and then click Properties, which opens the Database Properties dialog box.

  4. In the Select a Page pane, click Files.

  5. Look in the Database files grid for a list of the data and log files and their properties.

Using Transact-SQL

To view the data and log files in a backup set

  1. Connect to the [!INCLUDEssDE].

  2. From the Standard bar, click New Query.

  3. Use the RESTORE FILELISTONLY statement. This example returns information about the second backup set (FILE=2) on the AdventureWorksBackups backup device.

USE AdventureWorks2022;  
RESTORE FILELISTONLY FROM AdventureWorksBackups   
   WITH FILE=2;  
GO

See Also

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