Microsoft SQL Server 2016: Backing Up Databases

Course Overview

A tested backup strategy is the most effective means of protecting your data from media failure, user errors, hardware failures, and other potential disasters. This course teaches you about backing up data in SQL Server 2016, including backing up large databases, configuring alerting for backup issues, and managing translation log backups. In addition, this course covers backing up to Azure SQL Database, configuring recovery models, and automating backup jobs. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience

Database administrators and database professionals

Learning Objectives

• describe the reasons for backing up a database and supported backup types
• determine the appropriate strategy for backing up a database
• determine the appropriate media for backing up a database
• recognize how to plan a retention policy for backing up databases
• create a backup using SQL Server Management Studio
• create a backup using Transact-SQL
• describe how transaction log backup works
• create an automated backup job in SQL Server Management Studio
• describe the features and benefits of backing up a database to the Azure Blob Storage Service
• describe best practice and troubleshooting tips for backing up to the Azure Blob Storage Service
• back up a database to Azure
• describe the purpose of the three recovery models
• view and change recovery models using SQL Server Management Studio
• recognize how to view and change recovery models using Transact-SQL
• describe tasks that should be completed after changing the recovery model
• manage and implement a backup strategy in SQL Server 2016