Beginning backup and restore for SQL Server : data loss management and prevention techniques /: data loss management and prevention techniques. ([2018])

• Record Type: Book
• Further Information: Note: Bradley Beard.
• Authors: Beard, Bradley
• Contents: 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
• Publisher Details: New York : Apress
• Publication Date: 2018
• Copyright Date: 2018
• Extent: 1 online resource, illustrations
• Subjects: 005/.86; Computer science; SQL (Computer program language); Data recovery (Computer science); Database design; Database management; COMPUTERS / Databases / General; Data recovery (Computer science); Database design; Database management; SQL (Computer program language); Computer Science; Database Management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484234563; 1484234561; 1484234553; 9781484234556
• Related ISBNs: 9781484234556; 1484234553
• Notes: Note: Online resource ; title from PDF title page (EBSCO, viewed June 22, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.