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 5: Managing the Log in FULL Recovery Model

We'll start by taking a deeper look at log backups, including tail log backups, for databases in FULL recovery model and then at how to perform various database restore operations using these log backup files, in conjunction with full database backups.

FULL recovery model supports database restore to any point in time within an available log backup and, assuming we have a tail log backup, right up to the time of the last committed transaction before the failure occurred.

What Gets Logged?

In FULL recovery model, SQL Server fully logs all operations, meaning that it logs a set of records containing enough information, either at the page or row level, to make a roll forward possible. Certain ...

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