Chapter 15. Database Snapshots

After completing this chapter, you will be able to

  • Create a Database Snapshot

  • Revert a database from a Database Snapshot

Database Snapshots were introduced in SQL Server 2005 to provide users a method to rapidly create read-only copies of data. In this chapter, you learn how to create a Database Snapshot, as well as how to use a Database Snapshot to revert data or a database to a previous point in time.

Note

Note

Database Snapshots are available only in the Enterprise edition of SQL Server.

Caution

Caution

Database Snapshots are not compatible ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

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