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?
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 ...