O'Reilly logo

SQL Server Transaction Log Management by Tony Davis, Gail Shaw

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 3: Transaction Logs, Backup and Recovery

Unless your database is operating in SIMPLE recovery model, it is very important that you take regular log backups. This will control the size of the transaction log, and ensure that, in the event of a disaster, you are able to restore your database to some point shortly before the disaster occurred. These transaction log backups will be performed alongside regular full database (data file) backups, and possibly differential database backups.

If you're backing up a test system where you don't need to restore to a previous point in time, or it's clear from the Service Level Agreement (SLA) that you can meet database recovery requirements simply by restoring the most recent full (plus differential) ...

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