Post reply

What is a deferred txn?

  • August 8, 2011 at 8:26 am

    #255114

    Hi All,

    Can anyone give me an example of a defferred transaction to understand it better?

    http://msdn.microsoft.com/en-us/library/ms188290.aspx

    Thanks in advance.

  • August 8, 2011 at 10:13 am

    #1365337

    Peform a restore, get an I/O error at some point. Part of the IO error contains a set of operations needed to complete a transaction. The completion of the transaction is deferred.

    If you perform a log backup while a full backup is running, the clearing of the log (marking backed up portions as inactive), is deferred from the log backup until the full completes.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply