Wow – today is all about new content. As if I haven't already blogged about enough stuff to keep you reading through next week, the February issue of TechNet Magazine is now available and contains a feature article I wrote about understanding how logging and recovery work inside SQL Server.
The article covers:
What is logging?
What is recovery?
The transaction log (include logical and physical architecture)
Recovery models and how they affect the behavior of the transaction log
There's also a ten-minute screencast video where I demonstrate a runaway transaction log.
Check it out at http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx.