Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

As a database is recovering, after which phase will the database be available/online?

Dec 8 2012 12:00AM by Ankit Shah   

Question

As a database is recovering, after which phase will the database be available/online?

Answer

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.

Read More..   [32134 clicks]

Published under: DBA Interview Questions · SQL Server Interview Questions ·  ·  · 


Ankit Shah
298 · 0% · 147
2
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"As a database is recovering, after which phase will the database be available/online?" rated 5 out of 5 by 2 readers
As a database is recovering, after which phase will the database be available/online? , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]