Dropping a Database Snapshot

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

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

See Also

Tasks

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

Concepts

Creating a Database Snapshot

Other Resources

Database Snapshots