The Log, the whole Log and nothing but the Log

Play The Log, the whole Log and nothing but the Log
Sign in to queue


This session focuses on the transaction log. It begins with a quick glance on what goes on in and around the log in the different recovery modes. You'll then get a deep dive into log sequence numbers, how to find them and what that info means. The context for theese demos is the backup database and backup log commands. Finally you'll see a demo in which we will recover a database from a total data-drive crash without losing one single transaction.It's all about the log...





Download this episode

The Discussion

Add Your 2 Cents