Hi,

Please correct me if i'm wrong.
Before writing the data into the physical disk, it logs information in the transaction log and after that checkpoint is issued which propagates all the modified data/dirty pages from the log to the physical file. This is how the transaction log behaves i believe.

I heard that the dirty pages are pages which are changed after reading into the cache. I would like to know from where these pages are retrieved into the cache. Is it from transaction log or from the database file or this cache is in the transaction log per-se? I'm bit confused on this.


Thanks,
Chandra

__________________
Thanks,
Chandra