Using Database Snapshots

Database Snapshots is a new feature introduced in SQL Server 2005 which enables you to take a point-in-time, read-only snapshot of a database. A database snapshot can be queried as if it were just another user database and can exist for as long as needed. When you’re done using it, the database snapshot can be deleted or restored back onto the source database.


Database Snapshots are in no way related to snapshot backups, snapshot replication, or the new snapshot transaction isolation level.

How Database Snapshots Work

When a database snapshot is created, a view of a source database is captured as it exists at that point in time while eliminating any changes made by uncommitted transactions. Therefore, a database snapshot ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.