Drop a Database Snapshot (Transact-SQL)

  • Artykuł

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.

Security

Permissions

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

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

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.

[!UWAGA]

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

Ikona strzałki używana z łączem Powrót na górę strony[Top]

Zobacz także

Odwołanie

DROP DATABASE (Transact-SQL)

Koncepcje

Database Snapshots (SQL Server)