View the Data and Log Files in a Backup Set (SQL Server)
Applies To: SQL Server 2016
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
This topic describes how to view the data and log files in a backup set in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To view the data and log files in a backup set, using:
For information about security, see RESTORE FILELISTONLY (Transact-SQL)
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).
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 Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
Right-click the database, and then click Properties, which opens the Database Properties dialog box.
In the Select a Page pane, click Files.
Look in the Database files grid for a list of the data and log files and their properties.
Connect to the Database Engine.
From the Standard bar, click New Query.
Use the RESTORE FILELISTONLY statement. This example returns information about the second backup set (
FILE=2) on the
USE AdventureWorks2012 ; RESTORE FILELISTONLY FROM AdventureWorksBackups WITH FILE=2; GO