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.

Note

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.