How Often Should You Run Backups and CHECKDB?

Target Audience:

You’re responsible for making sure the database server doesn’t go down and that you don’t lose data.

Abstract:

You’ve been taking SQL Server full and log backups for a couple of years now, and you’ve even done a few successful restores when your butt was on the line. But now that you’ve decided to become a professional database administrator, you’re wondering what kinds of restoration problems you’re going to run into in the future. Are there patterns and practices that a Senior DBA would have taught you – if you were lucky enough to work alongside one? And if you need to run backups and CHECKDB more often, how can you make ’em run faster?

I want to help. I’m Brent Ozar, and I’ve worked with a lot of shops whose nightly maintenance tasks spiraled out of control. From long backups to corrupt restores to dropped tables, you’ll learn the kinds of server emergencies that have brought DBAs to their knees. I’ll show you how to prevent emergencies before they strike.

Why I Want to Present This Session:

Most servers I see have the same basic setup: full backups every day, log backups every hour, CHECKDB every week. Nobody thinks about how easy it would be to lose less data – until it’s way too late. Let’s start thinking about it now.

Additional Resources:

The following two tabs change content below.

Brent Ozar

Managing Director at Brent Ozar Unlimited
I make Microsoft SQL Server faster and more reliable. I'm the guy behind BrentOzar.com, Ozar.me, DBAreactions.com, SQLServerUpdates.com, and GroupBy.org.
Previous Post
I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!
Next Post
Getting Better Query Plans by Improving SQL’s Estimates

9 Comments. Leave new

You make this abstract writing exercise look easy. I would not change a thing. My favorite sessions are the ones that pass on “real world” tips. I like how you sandwiched the abstract with who needs this session with the why describing a situation that I’m sure many people can identify with.

Reply

    Thanks man! Yeah, I try to really focus on YOU YOU YOU – reach out and grab exactly the right attendee by talking to them personally. This is where writing the target attendee profile and the recap slide really help.

    Reply

I’m going through these abstracts and I want to watch all of them so far. This would be great to have in the lineup.

Reply
Rick Kohler
March 6, 2018 3:59 pm

I’ll watch.

Reply

I would attend. Thanks!

Reply

[…] How Often Should You Run Backups and CHECKDB? […]

Reply

It sounds good. Very practical to apply. Personally, what I would love is something that will help me decide on a design for an HADR plan. I researched mirroring , log shipping and enough about AG’s to know that the company I work for doesn’t need such a complex system. But between mirroring and log shipping , I am having a hard time finding a resource that will give me an overview so that I have an overall understanding of the options available enough to feel confident in choosing one and continue to develop it. I am not suggesting improvements on your abstract, because it’s just a totally different topic, maybe it’s more of a suggestion for a future abstract or maybe there is resource that you can point me to that would have that information. It’s almost that I would like an abstract on what you need to know before designing a backup/recovery plan.

Reply

This sounds really interesting.

Reply

Leave a Reply to Rick Kohler Cancel reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu