Press "Enter" to skip to content

Eager Writes and Minimally Logged Operations

Paul Randal answers a question:

I had an email discussion with someone last week who was wondering about log backups and minimally-logged operations. Specifically they were confused as to how the log backup works if no checkpoint has occurred since the operation completed. Surely the data pages are still dirty in memory?

Not so.

Read on to learn more about eager writing.