Timeline for If i issue a rollback when recovery mode is bulk logged, will my bulk operations be rolled back?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 28, 2021 at 21:04 | comment | added | mrdenny | When a minimally logged transaction happens, that transaction is the only one that is writing to the pages in question. So in your example the minimally logged transaction is the only one writing to the pages that are being allocated to tmp_created_in_txn. If another tran needed to write it would need a new page. When the rollback happens, the log simply tracks page numbers, and all those pages are reset to blank. | |
| Jun 28, 2021 at 19:42 | history | edited | Rory | CC BY-SA 4.0 | added 8 characters in body |
| Jun 28, 2021 at 19:39 | vote | accept | Rory | ||
| Mar 13, 2012 at 14:45 | comment | added | jcolebrand♦ | Welcome to any SE site, where Jeapordy Q are just fine. However, there's some rumbling that you've raised more questions with this. I've asked those doing the rumbling to kindly ask you those Q. We shall see. | |
| Mar 13, 2012 at 14:31 | history | answered | Rory | CC BY-SA 3.0 |