O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

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

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