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
  • Locked
    4. 
    Backup Retention Policies
    4m 49s
  • Locked
    5. 
    Creating Backups using SSMS
    8m 4s
  • Locked
    6. 
    Creating Backups using T-SQL
    4m 35s
  • Locked
    7. 
    Transaction Logs and Backups
    8m 10s
  • Locked
    8. 
    Automating Backup
    8m 14s
  • Locked
    9. 
    Backups to Azure Blob Storage Service
    6m 55s
  • Locked
    10. 
    Azure Blog Storage Service Backup Considerations
    5m 38s
  • Locked
    11. 
    Backing Up a Database to Azure Blob Storage Service
    5m 13s
  • Locked
    12. 
    Recovery Models
    8m 39s
  • Locked
    13. 
    Managing Recovery Models with SSMS
    2m 31s
  • Locked
    14. 
    Managing Recovery Models with T-SQL
    4m 26s
  • Locked
    15. 
    Recovery Model Recommendations
    3m 37s
  • Locked
    16. 
    Exercise: Managing Backup In SQL Server 2016
    6m 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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 34 Likes 34  
Likes 110 Likes 110  
Likes 37 Likes 37