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


4 comments:

happynewyear 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

Harry kevin said...

I was reading phases of database recovery and it was interesting how every recovery process depends on proper planning and organization to avoid bigger problems later. Student life feels very similar because managing assignments and deadlines also requires a structured approach. Many students look for assignment writing service in Edinburgh when academic workload starts becoming difficult to balance with other responsibilities. In university discussions UK assignment help is sometimes mentioned while students talk about managing pressure and staying on top of their coursework.

Post a Comment

Ads