sql2005培训资料07.pptVIP

Module 7: Disaster Recovery Overview Disaster Recovery in SQL Server 2005 Using Database Snapshots Backup and Restore Operations Disaster Recovery in SQL Server 2005 Lesson: Using Database Snapshots What Are Database Snapshots? How to Manage Database Snapshots Demonstration: Creating a Database Snapshot How to Use a Database Snapshot to Recover Data What Are Database Snapshots? Read-only, consistent view of a database Specified point-in-time Modifying data Copy-on-write of affected pages Reading data Accesses snapshot if data has changed Redirected to original database otherwise How to Manage