Backup Management

SQL    |    Intermediate
  • 16 videos | 1h 42m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)
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

  • 10m 36s
    After completing this video, you will be able to describe the reasons for backing up a database and the types of backups that are supported. FREE ACCESS
  • 7m 17s
    In this video, find out how to determine the appropriate strategy for backing up a database. FREE ACCESS
  • Locked
    3.  Backup Media
    6m 57s
    During this video, you will learn how to determine the appropriate media for backing up your database. FREE ACCESS
  • Locked
    4.  Backup Retention Policies
    4m 49s
    Upon completion of this video, you will be able to recognize how to plan a policy for backing up databases. FREE ACCESS
  • Locked
    5.  Creating Backups using SSMS
    8m 4s
    In this video, you will learn how to create a backup using SQL Server Management Studio. FREE ACCESS
  • Locked
    6.  Creating Backups using T-SQL
    4m 35s
    In this video, you will learn how to create a backup using Transact-SQL. FREE ACCESS
  • Locked
    7.  Transaction Logs and Backups
    8m 10s
    Upon completion of this video, you will be able to describe how transaction log backups work. FREE ACCESS
  • Locked
    8.  Automating Backup
    8m 14s
    In this video, you will learn how to create an automated backup job in SQL Server Management Studio. FREE ACCESS
  • Locked
    9.  Backups to Azure Blob Storage Service
    6m 55s
    After completing this video, you will be able to describe the features and benefits of backing up a database to Azure Blob Storage Service. FREE ACCESS
  • Locked
    10.  Azure Blog Storage Service Backup Considerations
    5m 38s
    Upon completion of this video, you will be able to describe best practices and troubleshooting tips for backing up to the Azure Blob Storage Service. FREE ACCESS
  • Locked
    11.  Backing Up a Database to Azure Blob Storage Service
    5m 13s
    Learn how to back up a database to Azure. FREE ACCESS
  • Locked
    12.  Recovery Models
    8m 39s
    After completing this video, you will be able to describe the purpose of the three recovery models. FREE ACCESS
  • Locked
    13.  Managing Recovery Models with SSMS
    2m 31s
    In this video, you will learn how to view and change recovery models using SQL Server Management Studio. FREE ACCESS
  • Locked
    14.  Managing Recovery Models with T-SQL
    4m 26s
    Upon completion of this video, you will be able to recognize how to view and change recovery models using Transact-SQL. FREE ACCESS
  • Locked
    15.  Recovery Model Recommendations
    3m 37s
    Upon completion of this video, you will be able to describe tasks that should be completed after changing the recovery model. FREE ACCESS
  • Locked
    16.  Exercise: Managing Backup In SQL Server 2016
    6m 37s
    In this video, you will learn how to manage and implement a backup strategy in SQL Server 2016. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Google Cloud Digital Leader: Storage Options for Structured Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Google Associate Cloud Engineer: Data & Storage Management
Course Backup & Recovery: Business Continuity & Disaster Recovery
Rating 4.7 of 471 users Rating 4.7 of 471 users (471)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Monitoring Database Activity
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
Course Data Security & Azure SQL Database Options
Rating 4.6 of 67 users Rating 4.6 of 67 users (67)
Course SSIS Components
Rating 4.5 of 28 users Rating 4.5 of 28 users (28)