view-a-database-snapshot-sql-server.md

title	View a Database Snapshot (SQL Server) | Microsoft Docs
description	Learn how to view a SQL Server database snapshot using SQL Server Management Studio or Transact-SQL.
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	supportability
ms.topic	conceptual
helpviewer_keywords	database snapshots [SQL Server], viewing displaying database snapshots viewing database snapshots
ms.assetid	123f19b2-0850-4033-8507-59ebdfb368ee
author	stevestein
ms.author	sstein

View a Database Snapshot (SQL Server)

[!INCLUDE SQL Server] This topic explains how to view a [!INCLUDEssNoVersion] database snapshot using [!INCLUDEssManStudioFull].

Note

To create, revert to, or delete a database snapshot, you must use [!INCLUDEtsql].

In This Topic

• To view a database snapshot, using:

  SQL Server Management Studio

  Transact-SQL

Using SQL Server Management Studio

To view a database snapshot

1. In Object Explorer, connect to the instance of the [!INCLUDEssDEnoversion] and then expand that instance.

2. Expand Databases.

3. Expand Database Snapshots, and select the snapshot you want to view.

Using Transact-SQL

To view a database snapshot

1. Connect to the [!INCLUDEssDE].

2. From the Standard bar, click New Query.

3. To list the database snapshots of the instance of [!INCLUDEssNoVersion], query the source_database_id column of the sys.databases catalog view for non-NULL values.

Related Tasks

• Create a Database Snapshot (Transact-SQL)

• Revert a Database to a Database Snapshot

• Drop a Database Snapshot (Transact-SQL)

See Also

Database Snapshots (SQL Server)