Interview Questions - While database is recovering, after which phase will the database be available/online?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

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

Jul 19 2012 12:00AM by Ankit Shah

Question

While 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.. [89 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: Please give Answer without use of SSMS(Substring knowledge)
Next: What is MSX / TSX in SQL Agent ?

Ankit Shah

291 · 0% · 147

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"While database is recovering, after which phase will the database be available/online?" rated 5 out of 5 by 6 readers

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

Question

Answer

Your Comment