Backup Management

SQL 2016    |    Intermediate
  • 16 Videos | 1h 42m 16s
  • Includes Assessment
  • Earns a Badge
Likes 75 Likes 75
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 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

IN THIS COURSE

  • Playable
    1. 
    Database Backups
    10m 36s
    UP NEXT
  • Playable
    2. 
    Backup Strategies
    7m 17s
  • Locked
    3. 
    Backup Media
    6m 57s
    FREE ACCESS
  • Locked
    4. 
    Backup Retention Policies
    4m 49s
    FREE ACCESS
  • Locked
    5. 
    Creating Backups using SSMS
    8m 4s
    FREE ACCESS
  • Locked
    6. 
    Creating Backups using T-SQL
    4m 35s
    FREE ACCESS
  • Locked
    7. 
    Transaction Logs and Backups
    8m 10s
    FREE ACCESS
  • Locked
    8. 
    Automating Backup
    8m 14s
    FREE ACCESS
  • Locked
    9. 
    Backups to Azure Blob Storage Service
    6m 55s
    FREE ACCESS
  • Locked
    10. 
    Azure Blog Storage Service Backup Considerations
    5m 38s
    FREE ACCESS
  • Locked
    11. 
    Backing Up a Database to Azure Blob Storage Service
    5m 13s
    FREE ACCESS
  • Locked
    12. 
    Recovery Models
    8m 39s
    FREE ACCESS
  • Locked
    13. 
    Managing Recovery Models with SSMS
    2m 31s
    FREE ACCESS
  • Locked
    14. 
    Managing Recovery Models with T-SQL
    4m 26s
    FREE ACCESS
  • Locked
    15. 
    Recovery Model Recommendations
    3m 37s
    FREE ACCESS
  • Locked
    16. 
    Exercise: Managing Backup In SQL Server 2016
    6m 37s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

COURSE Multi-cloud Load Balancing: Disaster Backup & Recovery
Likes 0 Likes 0  
COURSE Microsoft Azure Architect Design: Azure Business Continuity Planning
Likes 10 Likes 10  
COURSE Introduction to AWS Backup
Likes 2 Likes 2  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Log Shipping & High Availability
Likes 34 Likes 34  
COURSE Data Access & Permissions
Likes 110 Likes 110  
COURSE Managing Database Integrity
Likes 37 Likes 37