Backup Management
SQL 2016
| Intermediate
- 16 Videos | 1h 42m 16s
- Includes Assessment
- Earns a Badge
A tested backup strategy is the most effective means of protecting your data from potential disaster. Explore SQL Server 2016 backup management practices, including backup strategies, media options, and retention and recovery models.
WHAT YOU WILL LEARN
-
describe the reasons for backing up a database and supported backup typesdetermine the appropriate strategy for backing up a databasedetermine the appropriate media for backing up a databaserecognize how to plan a retention policy for backing up databasescreate a backup using SQL Server Management Studiocreate a backup using Transact-SQLdescribe how transaction log backup workscreate an automated backup job in SQL Server Management Studio
-
describe the features and benefits of backing up a database to the Azure Blob Storage Servicedescribe best practice and troubleshooting tips for backing up to the Azure Blob Storage Serviceback up a database to Azuredescribe the purpose of the three recovery modelsview and change recovery models using SQL Server Management Studiorecognize how to view and change recovery models using Transact-SQLdescribe tasks that should be completed after changing the recovery modelmanage and implement a backup strategy in SQL Server 2016
IN THIS COURSE
-
1.Database Backups10m 36sUP NEXT
-
2.Backup Strategies7m 17s
-
3.Backup Media6m 57s
-
4.Backup Retention Policies4m 49s
-
5.Creating Backups using SSMS8m 4s
-
6.Creating Backups using T-SQL4m 35s
-
7.Transaction Logs and Backups8m 10s
-
8.Automating Backup8m 14s
-
9.Backups to Azure Blob Storage Service6m 55s
-
10.Azure Blog Storage Service Backup Considerations5m 38s
-
11.Backing Up a Database to Azure Blob Storage Service5m 13s
-
12.Recovery Models8m 39s
-
13.Managing Recovery Models with SSMS2m 31s
-
14.Managing Recovery Models with T-SQL4m 26s
-
15.Recovery Model Recommendations3m 37s
-
16.Exercise: Managing Backup In SQL Server 20166m 37s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.