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