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 14. Back Up Database (Transaction Log) Task

Earlier, I stated that the Back Up Database (Full) task is the most important maintenance task for DBAs to implement. Now we have come to the second most important task, the backing up of transaction logs, which is implemented using the Back Up Database Transaction Log) task.

In order to recover as much data as possible after the loss of a database, and to enable point-in-time recovery of your data, when using the full (or bulk-logged) recovery model, it is essential that you perform regular transaction log backups in addition to full backups (Chapter 12), and possibly differential backups (Chapter 13). The Back Up Database(Transaction Log) task allows you to schedule the backup of your transaction ...

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