Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

Dropping a Database Snapshot

Updated: 12 December 2006

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.

Dropping a database snapshot clears the plan cache for the instance of SQL Server. Clearing the plan cache causes a recompilation of all subsequent execution plans and can cause a sudden, temporary decrease in query performance. In SQL Server 2005 Service Pack 2, for each cleared cachestore in the plan cache, the SQL Server error log contains the following informational message: "SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or reconfigure operations". This message is logged every five minutes as long as the cache is flushed within that time interval.

To drop a database snapshot

Release History

12 December 2006

New content:
  • Added information about clearing the plan cache.

5 December 2005

Changed content:
  • Documented that an use database snapshot can be dropped.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.