Udostępnij za pośrednictwem

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

  • Artykuł

Any user in the database with DROP DATABASE permissions can drop a database snapshot by using Transact-SQL.

When you drop a database snapshot, all user connections to it are terminated.

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 (see How to: View a Database Snapshot (SQL Server Management Studio)).

  2. Issue a DROP DATABASE statement, specifying the name of the database snapshot to be dropped.

Example

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 How Database Snapshots Work.

See Also

Tasks

How to: Create a Database Snapshot (Transact-SQL)
How to: View a Database Snapshot (SQL Server Management Studio)
How to: Revert a Database to a Database Snapshot (Transact-SQL)

Other Resources

DROP DATABASE (Transact-SQL)
SQL Server Management Studio Tutorial

Help and Information

Getting SQL Server 2005 Assistance