Chapter 9. Database snapshots
After completing this chapter, you will be able to
Understand database snapshots.
Identify database snapshot prerequisites.
Create and view a database snapshot.
Drop a database snapshot.
Revert to a database snapshot.
A database snapshot is a static, read-only copy of an existing Microsoft SQL Server database. The existing database is referred to as the source database when discussing database snapshots. When a snapshot is created, it is an exact read-only replica of the source database at that point in time. As the source database changes, the snapshot will be updated to ensure that it is synchronized.
This chapter covers the information you need to determine when, how, and why to implement snapshots. Specifically, the ...
Get Microsoft® SQL Server® 2012 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.
