Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: View the Data and Log Files In a Backup Set (SQL Server Management Studio)
Collapse the table of content
Expand the table of content

How to: View the Data and Log Files In a Backup Set (SQL Server Management Studio)

This topic explains how to view the data and log files in a backup set.

To view the data and log files in a backup set

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

Community Additions

ADD
Show:
© 2015 Microsoft