Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction to Backup and Restore Methodologies; Part I: Backups; Chapter 1: Full Backups; What Is a Full Backup?; Recovery Models; Backup Types; How Do Recovery Models Affect the Backup Types?; Preparing for a Full Backup; Back Up Database: General Tab; Transaction Log Examination; Manually Backing Up the Database; Summary; Chapter 2: Differential Backups; What Is a Differential Backup?; Differential Backup Dependency; Why Use Differential Backups?; Scenario Without Differential Backups

Scenario Running Differential BackupsAdding Differential Backups to a Backup Solution; Preparing for a Differential Backup; Running a Differential Backup; Taking a Backup via the GUI in SSMS; Validating a Backup via the GUI in SSMS; Taking a Differential Backup via T-SQL; Summary; Chapter 3: Transaction Log Backups; What Is a Transaction Log?; Viewing Transaction Log Status; Backing Up a Transaction Log; Transaction Log Backups via Script; Transaction Log Backups via SSMS; Back Up Database-General; Back Up Database-Media Options; Back Up Database-Backup Options; Summary

Chapter 4: Backup Solution ExamplesSetting Up the Maintenance Plan; Full Backup Configuration; Differential Backup Configuration; Transaction Log Backup Configuration; Configuring the Jobs; Summary; Part II: Restores; Chapter 5: Full Restores; What Is a Full Restore?; Restoring the Master Database; Start SQL Server in Single-User Mode; Restore SQL Server to Multiuser Mode; Restoring from a Full Backup; Full Restores with SSMS; Restoring to a Point in Time; Emergency Full Restore Example; Summary; Chapter 6: Differential Restores; What Is a Differential Restore?; Restoring Using SSMS

Restoring Using T-SQLSummary; Chapter 7: Transaction Log Restores; Transaction Log Restore Fundamentals; Restoring Using SSMS; Restore Files and Filegroups-General; Restore Files and Filegroups-Options; Point-in-Time Restore/Recovery; Restoring Using Transact-SQL; Restore File and Filegroups Template; Summary; Chapter 8: Restore Solution Examples; Page Restores; Querying msdb..suspect_pages; Complete Database Restore Using T-SQL; Complete Database Restore Using SSMS; Database Snapshots; How Does a Database Snapshot Work?; Creating a Database Snapshot; Querying a Database Snapshot

Restoring a Database SnapshotViewing Backup and Restore History; Summary; Part III: Complete Solutions; Chapter 9: Full Backup and Restore Solutions; Full Backup Plan in SSMS; Defining the Back Up Database Task Options; Scheduling the Full Backup; Updating the SQL Server Agent Job; General Tab; Steps Tab; Job Step Properties - Subplan_1 (General Tab); Job Step Properties - Subplan_1 (Advanced Tab); Schedules Tab; Alerts Tab; Notifications Tab; Setting Up an Operator; Testing the Full Backup Plan; Full Restore Plan in SSMS; T-SQL Restore Command; SQL Server Agent Restore Job