What is Deferred transaction ?

 Posted by Pandians on 7/23/2009 | Category: Sql Server Interview questions | Views: 8703

A transaction that is not committed when the roll forward phase of recovery finishes, and that cannot be rolled back during database startup because the data required by rollback is offline. This data can reside in either a page or a file.

Asked In: In General | Alert Moderator 

Comments or Responses

Login to post response