SQL Server 2008 R2: Backups, Restores, and Database Snapshots
Professionals typically pursuing a career as a Database Administrator; individuals who don’t work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server
Enterprises use databases to store their most critical data. To protect and ensure the data’s availability, database administrators need to establish a solid backup and restoration plan. Such plans are used to protect data in the event of a disaster by allowing complete sets of duplicate data to be restored in a timely fashion. There are multiple types of backups that can be taken to ensure the recovery of data, including a full recovery or a point-in-time recovery. SQL Server 2008 R2 also offers database snapshots, which can be used to revert a database to a specific point when the snapshot was taken. This helps to store historical data and provides protection against administrative errors. This course demonstrates how to perform backup and recovery operations, as well as how to create database snapshots and revert to a database snapshot. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Backups, Restores, and Database Snapshots
- match the recovery models to their characteristics
- identify the considerations for a backup and restore strategy
- recognize how to perform a database backup
- recognize how the restore process works
- recognize how to restore a SQL Server backup
- recognize the characteristics of a database snapshot
- recognize how to configure a database snapshot
- backup a database
- restore a database