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
The databases undergo recovery phases in two scenarios
- When the SQL server or service is restarted
- When the database is being restored.

Recovery Phases - Drill Down

Recovery Phases - Graphical

1 comment:
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
Post a Comment