Microsoft SQL Server 2016: Backing Up Databases

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
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

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Microsoft SQL Server 2016: Backing Up Databases

start the course

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

Course Number:
df_sqla_a04_it_enus

Expertise Level
Intermediate