From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Define a backup and recovery strategy

Define a backup and recovery strategy - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Define a backup and recovery strategy

“

Obviously, taking backups of all your databases is important and it's something you should do fairly regularly in case disaster strikes and you have to restore. However, there's more considerations to how you design your backup strategy than just backup the databases. This lesson, really, we're going to have a brief conversation, look at a couple options in the tool as we do it. But we're going to talk about things you should consider for your backup strategy. So we know there are different kinds of backups in SQL Server, and I'm just going to bring up the backup dialog so we can kind of talk through some of these. You have your fulls, you have your differentials, and you have your T-logs. T-logs are available when the database is not in simple recovery mode. So when you start designing a backup strategy, you have to consider a few things. First, the size of your database is going to make a bit of a difference, right? The reason is if I have a 10 gig database or 100 gig or a terabyte…

Contents