Beginning backup and restore for SQL Server : data loss management and prevention techniques /: data loss management and prevention techniques. ([2018])
- Record Type:
- Book
- Title:
- Beginning backup and restore for SQL Server : data loss management and prevention techniques /: data loss management and prevention techniques. ([2018])
- Main Title:
- Beginning backup and restore for SQL Server : data loss management and prevention techniques
- 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;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 … (more)
- 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.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.360016
- Ingest File:
- 01_322.xml