Timeline for How does sql server know whether the dirty pages have been written to the data file?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 5, 2022 at 7:10 | comment | added | Michael Green | SQL Server follows the ARIES recovery protocol, like several other systems. It's a bit involved but well documented. | |
| Oct 4, 2022 at 17:56 | vote | accept | variable | ||
| Oct 4, 2022 at 17:45 | answer | added | SqlWorldWide | timeline score: 2 | |
| Oct 4, 2022 at 17:23 | comment | added | variable | But eventually it needs to write it to the data pages on the disk. I'm trying to understand how sql server knows which data pages are yet to be written to disk in the given scenarios. | |
| Oct 4, 2022 at 17:20 | comment | added | Sean Gallardy | Generically, it doesn't, nor does it really care. The DPT (dirty page table) will be re-created upon recovery. learn.microsoft.com/en-us/sql/relational-databases/… | |
| Oct 4, 2022 at 16:46 | history | edited | variable | CC BY-SA 4.0 |
added 44 characters in body
|
| Oct 4, 2022 at 16:32 | history | asked | variable | CC BY-SA 4.0 |