Phases of Database recovery | SansSQL

Friday, July 27, 2012

Phases of Database recovery

From my previous post “What happens when a SQL Server instance is restarted?” we know what activities will be carried out when the SQL Server instance gets restart request.
Now, it’s time to understand what recovery phases the database will undergo.
The databases undergo recovery phases in two scenarios
  1. When the SQL server  or service is restarted
  2. When the database is being restored.
There are 3 Phases of Recovery and are based on the last checkpoint in the transaction log.

Recovery Phases - Drill Down


Recovery Phases - Graphical


3 comments:

Unknown said...

Hi Sandesh,

The DB undergo recovery process in these scenario as well 1) A cluster fail over occurs 2) a database is being attached 3) a database is brought online

Huongkvb said...

Mua vé máy bay tại Aivivu, tham khảo

Ve may bay di My

bán vé máy bay từ mỹ về việt nam

mua vé máy bay từ đức về việt nam

chuyen bay nhat viet

đặt vé máy bay từ hàn quốc về việt nam

từ canada về việt nam quá cảnh ở đâu

bảng giá khách sạn cách ly tphcm

ve may bay chuyen gia nuoc ngoai sang Viet Nam

John said...

Myle V5 Pods smooth flavor aur easy-to-use design ke sath ek reliable vaping experience provide karte hain. Myle v5 pods

Post a Comment

Ads