- What is the role of eager writer? How this process works internally in SQL server?
- What is the major difference between eager writer and lazy writer/checkpoint? My understanding here is, that both eager and lazy writer are doing the same job - hardening dirty pages to disk. Is my understanding correct or am I missing any thing over here?
- I've read at some blog that, "there is no chance for roll forward operation in bulk logged recovery model as the trasactions are minimally logged". If we take the case where a log backup consists of minimally logged transactions, how could this log restore can become successful without any roll forward operation?
I really confused with above questions. Please help me in learning more about eager writer.