From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Understand data recovery fundamentals

Understand data recovery fundamentals - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Understand data recovery fundamentals

“

SQL Server houses a lot of important data. So you need to have a plan in place for when and if something breaks and you lose your database or you lose your server. Now typically you're going to build servers that have redundancy and hard drives or redundancy in systems, and you're going to do your best to prevent anything from ever being lost, but eventually it will happen. And in SQL Server, the primary way that you're going to make sure you're prepared for loss is through data backups. You can have secondary servers, you can have all kinds of other things, but you need to make sure you have backups in place. You have a couple of different options when it comes to backups and we have lessons that are going to walk through all of these choices. You can do full database backups, you can do partial backups, backing up just the logs, which are smaller, you can do kind of incremental backups that get everything since the last full backup. And there's different ways you can slice this and…

Contents