While database is recovering, after which phase will the database be available/online?
Answer (SQL Server 2000): After the Undo phase.
Answer (SQL Server 2005): In all editions but Enterprise, after the Undo phase (if running FULL recovery model). With Enterprise edition, after the Redo phase. Fast recovery is possible because transactions that were uncommitted when a crash occurred reacquire whatever locks they held before the crash. While these transactions are being rolled back, their locks protect them from interference by users.
SQL Server Interview Questions · · · ·