Skip to content

drop-a-database-snapshot-transact-sql.md

Latest commit

 

History

History
64 lines (45 loc) · 3.19 KB

drop-a-database-snapshot-transact-sql.md

File metadata and controls

64 lines (45 loc) · 3.19 KB
title Drop a Database Snapshot (Transact-SQL) | Microsoft Docs
description Learn how to drop a database snapshot by using Transact-SQL, which deletes the snapshot from SQL Server and the sparse files that are used by the snapshot.
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology supportability
ms.topic conceptual
helpviewer_keywords
removing database snapshots
deleting database snapshots
database snapshots [SQL Server], deleting
ms.assetid ad70ec97-d5fb-41aa-b72a-915e74b61b76
author WilliamDAssafMSFT
ms.author wiassaf

Drop a Database Snapshot (Transact-SQL)

[!INCLUDE SQL Server] Dropping a database snapshot deletes the database snapshot from [!INCLUDEssNoVersion] 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 [!INCLUDEssManStudioFull]. 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.

Note

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

Related Tasks

See Also

DROP DATABASE (Transact-SQL)
Database Snapshots (SQL Server)