Course Hero Logo

2780B_03.ppt - Module 3: Disaster Recovery Overview...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 13 out of 40 pages.

Module 3:Disaster Recovery
OverviewPlanning a Backup StrategyBacking Up User DatabasesRestoring User DatabasesPerforming Online Restore OperationsRecovering Data from Database SnapshotsSystem Databases and Disaster Recovery
Lesson 1: Planning a Backup StrategySQL Server Backup TypesWhat Are Recovery Models?What Is a Full Database Backup Strategy?What Is a Database and Transaction LogBackup Strategy?What Is a Differential Backup Strategy?What Is a File or Filegroup Backup Strategy?Considerations for Backup OperatorsConsiderations for Backup Media
SQL Server Backup TypesBackup TypeDescriptionFullAll data files and part of the transaction logTransaction logAny database changes recorded in the log filesTail-logThe active portion of the logDifferentialThe parts of the database that have changed sincethe last full database backupFile / FilegroupSpecified files or filegroupsPartialThe primary filegroup, every read/write filegroup, andany specified read-only filegroupsCopy-onlyThe database or log (without affecting the backupsequence)
What Are Recovery Models?Recovery ModelDescriptionSimpleUses full or differential copies of thedatabase.Truncates the transaction logs.FullIncludes both database backups andtransaction log backups.Bulk-loggedIncludes both database and transactionlog backups, but uses less log space forsome operations.
What Is a Full Database Backup Strategy?Perform full backups if:Database is smallDatabase has few changes or is read-onlyClear transaction log periodically if using the fullrecovery modelSundayMondayTuesday
What Is a Database and Transaction LogBackup Strategy?Combine a database and transaction log backup if:Database is often modifiedFull backup takes too longSundayMonday
What Is a Differential Backup Strategy?Use differential backups if:Database changes frequentlyYou want to minimize backup timeBack up transaction logs separatelyMondayTuesday
What Is a File or Filegroup Backup Strategy?Use file or filegroups if:Database is very largeA full backup would take too longBack up transaction logs separatelyCan be complex to manageSundayMondayTuesdayWednesdayDatafile 1Datafile 2Datafile 3
Considerations for Backup OperatorsMembers of the following roles have permission to backup the database:sysadmindb_ownerdb_backupoperator
Considerations for Backup MediaSQL Server supports backing up to:TapeDiskBackup deviceA physical storage location for backup filesBackup setA backup on one or more backup devices
Lesson 2: Backing Up User DatabasesHow to Perform a Full Database BackupHow to Perform a Transaction Log BackupHow to Perform a Differential BackupHow to Perform File and Filegroup BackupsOptions for Ensuring Backup IntegrityPractice: Backing Up a Database

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 40 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture