Managing Backup and Restore of Databases in SQL Server 2016 Online Training

Taught by

UPDATED: March 2, 2021

Intermediate

Virtual Labs

This intermediate SQL Server 2016 training covers backup and restore techniques to ensure database continuity. You’ll learn to back up to Azure, recover from database corruption, automate backups, and use T-SQL for database management. This Microsoft SQL course will give you a solid understanding of maintaining data security and integrity in SQL Server 2016.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

Backing up databases to Azure
Identifying and recovering from database corruptions
Automating backups and restorations
Using the T-SQL commands necessary for removing unnecessary databases and backup histories

FAQs

What exactly is meant by backup and restoration of databases?

Backup and restoration of a database refers to making copies of all the data in a database (and its schema) so that it's protected against data loss or corruption. A database backup captures what's called the state of the database, including the data, configurations, and logs. Restoration is the process of using a backup to recover lost or damaged data, returning the database to a consistent and usable state.

What is the best backup strategy when using SQL Server?

The backup strategy that ensures the most comprehensive data protection with SQL Server 2016 involves full, differential, and transaction log backups done on a regular basis. A full backup is one that captures the entire database. A differential backup captures changes since the last full backup. Transaction log backups record transactional changes. Another essential part of the strategy is backup storage: offsite, regularly tested and complete with retention and restoration policies.

Why are backup and restoration procedures important when working with databases?

Backup and restoration is a crucial part of database management for two key reasons: data integrity and business continuity. Backup and restoration procedures, policies or strategies are different ways of making sure that an organization never loses access to its data and is always confident of its accuracy, even despite hardware failures (which happen all the time), software errors (which can always occur), or malicious activities (which are practically inevitable).

What are some things that can go wrong when backing up and restoring databases?

Many different things can go wrong and result in data loss or downtime when backing up and restoring databases, from errors to mistakes and failures. Some errors include possibilities like incomplete or corrupted backups, insufficient storage capacity, and compatibility issues between backup and restore environments. Humans can always make mistakes, as seen in misconfigurations or accidental deletion of backup files. And hardware, network and software failures are always a possibility.

Can I perform database restores across different SQL Server versions in SQL Server 2016?

As a general rule, SQL Server tries to support restoring databases across different versions, but as with any technology, there are limitations. Most versions of SQL Server are able to restore databases saved in older versions and maintain most of the functionality that was present in the previous version. However, restoring a database from a newer version to an older version is rarely possible due to potential compatibility issues and schema changes.

Who is this for?

This Managing Backup and Restore of Databases in SQL Server 2016 training is considered associate-level Microsoft training, which means it was designed for database administrators with at least a year of experience with database backup and recovery technologies and experienced database administrators looking to validate their Microsoft skills.

What our learners say

CBT Nuggets fits into my day-to-day amazingly.
John M. | IT Manager
Practice exams help you have an overview of your readiness. If you have failed a couple questions in one area, you can go back and work on them.
Harold M. | Network Administrator
Having access to on-demand labs that I could spin up instantly was very helpful. I didn’t have to have a home environment with a bunch of virtual machines spun up. Or worry about destroying things.
Brian V. | Monitoring Engineer

Study plan

Download the free Managing Backup and Restore of Databases in SQL Server 2016 Online Training study plan to complete this course in about 3 hours.

Download study plan