How to select a backup strategy to meet recovery time and recovery point objectives
How to back up databases and transaction logs
How to manage backups
How to restore databases
How to perform a point-in-time recovery
Is your data protected against disaster? Database administrators, regardless of platform need to be ready, whether working with SQL Server 2016, SQL Server v.Next on Linux, or Azure SQL Databases.
In this course, which is part of the SQL Server Database Administration series, you’ll explore the various recovery models you can set up.
Learn about your choices for system backup and gain an understanding of how to back up and recover SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases. Then you’ll actually do a backup. Plus, get practical tips on how to restore a SQL Server database.
This computer science course introduces features and technologies for recovering data. Topics include: SQL Server Recovery Models, Backup of SQL Server Databases, and Restoring SQL Server Databases.
Module 1: SQL Server Recovery Models
This module introduces the recovery models in SQL Server, which define the use of the transactions log and determine backup and recovery options available in SQL databases
Module 2: Backup of SQL Server Databases
This module covers backup types and options, and describes options for managing backups.
Module 3: Restoring SQL Server Databases
This module covers restore processes and sequencing, and options such as geo-redundancy in Azure.
After the final module you will take final exam, which accounts for 30% of your grade and will be combined with the homework assignments in each module to determine your overall score. You must achieve an overall score of 70% or higher to pass this course and earn a certificate.
Familiarity with database concepts and basic SQL query syntax.
A willingness to learn actively and persevere when troubleshooting technical problems is essential.