SQLBits 2020

Building a Better Backup Strategy

Learn how backup and restore work and how to put together an effective backup strategy.

Database backups are often critical for recovering from a disaster, but there are lots of misconceptions about how backups work and what a good backup strategy is. The purpose of taking backups is, of course, to be able to restore them at some point - but that can sometimes be easier said than done, depending on what you want to be able to restore. In this session, Paul will explain how the three most common types of backups work and how they can be combined into effective backup strategies. Paul will also cover how restore works and what you can do to make your restores run faster. This session provides the knowledge you need to make sure you can recover within your downtime target.