Get Better SQL Server Recovery by Grabbing The Log By The Tail

1,512 views · Published 28 December 2012 · 5:46 · Indexed 14 November 2026

Channel: Pluralsight · 2012 · Education

Watch on YouTube

Watch the full HD course:  http://pluralsight.com/training/courses/TableOfContents?courseName=sqlserver-logging

While the Mayans may have been proven to be a tad pessimistic, a SQL Server outage is considerably more likely.  In this video excerpt from Paul Randal's new course SQL Server: Logging, Recovery, and the Transaction Log you'll see how to use the "Tail of the log" backup to recover data that might have otherwise been missed in a standard backup.  In the full course Paul covers other topics such as transaction log architecture, checkpoints, and VLF fragmentation.

-~-~~-~~~-~~-~-
Push your limits. Expand your potential. Smarter than yesterday-
https://www.youtube.com/watch?v=k2s77i9zTek
-~-~~-~~~-~~-~-

More from this channel