O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required