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

Vanessa said...

Discover compassionate care at Nashville Behavioral Health, where our expert team provides personalized mental health and behavioral support for individuals of all ages. We help you build a healthier, more balanced life. nashville behavioral health

Post a Comment

Ads