Export (0) Print
Expand All

Drop a Database Snapshot (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Dropping a database snapshot deletes the database snapshot from SQL Server and deletes the sparse files that are used by the snapshot. When you drop a database snapshot, all user connections to it are terminated.


Any user with DROP DATABASE permissions can drop a database snapshot.

To drop a database snapshot

  1. Identify the database snapshot that you want to drop. You can view the snapshots on a database in SQL Server Management Studio. For more information, see View a Database Snapshot (SQL Server).

  2. Issue a DROP DATABASE statement, specifying the name of the database snapshot to be dropped. The syntax is as follows:

    DROP DATABASE database_snapshot_name [ ,...n ]

    Where database_snapshot_name is the name of the database snapshot to be dropped.

Example (Transact-SQL)

This example drops a database snapshot named SalesSnapshot0600, without affecting the source database.

DROP DATABASE SalesSnapshot0600 ;

Any user connections to SalesSnapshot0600 are terminated, and all of the NTFS file system sparse files used by the snapshot are deleted.


For information about the use of sparse files by database snapshots, see Database Snapshots (SQL Server).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft