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 Database Snapshots Demonstration: Creating a Database Snapshot In this demonstration, you will see how to: Create a database snapshot Access a database snapshot Examine database snapshot file growth How to Use a Database Snapshot to Recover Data Lesson: Backup and Restore Operations Changes to Backing Up Databases Changes to Restoring Databases How to Perform an Online Restore Media Reliability How to Recover the master Database Changes to Backing Up Databases Transact-SQL BACKUP statement – no support for BACKUP LOG WITH NO_LOG and BACKUP LOG WITH NO_TRUNCATE Data and differential backups include enough log to restore to a consistent state Partial backups enable piecemeal restore of a simple recovery model database Copy-only backups enable a copy to be taken that does not affect standard backup sequence Changes to Restoring Databases Transact-SQL RESTORE statement – RESTRICTED_USER replaces DBO_ONLY Point-in-time recovery Partial restore operations level restore operations Piecemeal restore operations How to Perform an Online Restore Only in Enterprise Editions Only for full or bulk-logged recovery models By default, restoring a file or a page is automatically an online restore Filegroup offline when any file within it is being restored Database offline during restore of any files in the primary filegroup Media Reliability Use CHECKSUM option of BACKUP and RESTORE statements