Skip to content

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

Latest commit

 

History

History
83 lines (58 loc) · 3.87 KB

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

File metadata and controls

83 lines (58 loc) · 3.87 KB
title View the Data and Log Files in a Backup Set (SQL Server) | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology backup-restore
ms.topic conceptual
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
ms.assetid abb6420c-f809-426e-aeb4-d0a74989cf39
author MikeRayMSFT
ms.author mikeray
manager craigg

View the Data and Log Files in a Backup Set (SQL Server)

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

In This Topic

Before You Begin

Security

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

Permissions

In [!INCLUDEssKatmai] 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 AdventureWorks2012 ;  
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)