O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Back Up Database (Differential) Task

As you can guess from its name, this task is designed to create differential backups, in other words, to back up all changes in a database since the last full backup.

Performing differential backups is not a substitute for making regular transaction log backups. If your databases are in the full recovery mode, transaction log backups must be included in your overall backup strategy alongside full backups and any differential backups.

For reasons that will become clear as we progress through the chapter, I generally avoid performing differential backups if I can, preferring to rely on a combination of full and transaction log backups. Furthermore, if your database maintenance requirements do include ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required