Partilhar via


How to: View a Database Snapshot (SQL Server Management Studio)

This topic explains how to view a database snapshot in Object Explorer.

Note

To create, revert to, or delete a database snapshot, you must use Transact-SQL.

To view a database snapshot on a server

  1. In Object Explorer, connect to the instance of the Microsoft SQL Server Database Engine and then expand that instance.

  2. Expand Databases.

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

See Also

Tasks

How to: Create a Database Snapshot (Transact-SQL)
How to: Revert a Database to a Database Snapshot (Transact-SQL)
How to: Drop a Database Snapshot (Transact-SQL)

Concepts

Database Snapshots

Other Resources

SQL Server Management Studio Tutorial

Help and Information

Getting SQL Server 2005 Assistance