Three phases of recovery: analysis phase, re-phase, and finally, phase-out

Question

Restoring a SQL Server database consists of three phases: the analysis phase, the retry phase, and finally the undo phase.

Can someone explain clearly or give a good link to these three stages of recovery?

Answer 1

From Understanding how restore and restore backups work in SQL Server

Recovery is a multiphase process. Possible recovery steps include copying data, replay (fast forward), and undo (roll back) phases:

• , .
• ,
  . , | . .
• , , .
  .

Answer 2

:

- . , ( ) ():

• , .
• . , . .
• , , . .

:

https://technet.microsoft.com/en-us/library/ms191455(v=sql.105).aspx

https://community.emc.com/docs/DOC-13849

Answer 3

: SQL Server

, .

1: . . (DPT), , SQL Server. SQL Server.

2: . SQL. , . - ( LSN) DPT - , SQL Server , , , .

3: : ( SQL Server), , 1, . SQL Server . , SQL Server, .

, ( ).

Answer 4

: Commit , , , ( ). , , , . .

, SQL- , . , . ( 2) . , .