Here is from BOL:
"The undo (roll back) phase is the last phase of a restore sequence. The undo phase ends a restore sequence by rolling back any uncommitted transactions....."
Thanks,|||Additional info. Here is cut/paste from High Availability presentation.
Restart Recovery has two phases:
?REDO: rolls forward committed transactions
?UNDO: rolls back any incomplete transactions
?On the Enterprise Edition of SQL Server 2005, users are allowed access after REDO
So the point is REDO phase is done first.
Thanks,|||So I guess my question is those people that want pages for which locks are held for undo, when do they get to get to those pages. When the whole undo is finished for all locked pages, when their particular page of interest is recovered? As well, if you locked 5 pages for undo, and SQL Server processed undo in page order 1,2,3,4,5 -- but you had TX's waiting on 5 and the process to undo was on page 2, could SQL Server bump to page 5 and undo that one, and then go back to 3 to service that waiting user faster?
I'm just trying to understand the model compared to Oracle, that's all. We're trying to prove the enterprise-like feature that 2005 has. And even if it isn't the same, I just need to arm myself. This is better than what DB2 has ..|||Undo is done in the reverse order of the transaction log generation. No, the undo will not go to page 5 and then go to page 3 if there is some transaction wainting to access page 5.
Thanks
No comments:
Post a Comment