Tuesday, July 3, 2012

What Is Deferred Transactions and When It Occur?

What IS Deferred Transaction?
Deferred transaction is a transaction that is uncommitted when the roll forward phase finishes and has encountered an error, its not possible to rollback as well because the transaction is deferred.

When Deferred Transaction Occur?
Usually deferred transaction occur when a piecemeal restore recovers a database to a point at which one or more active transactions are affecting a filegroup that has not yet been restored. Because the transactions cannot be rolled back, they become deferred.

If an error at the file level can also cause deferred transactions, Deffered transactions occurred mostly because filegroup was offline, to bring the filegroup online run below command.

RESTORE DATABASE database_name FILEGROUP= filegroup_name

Deferred transaction can also occur while the database was being rolled forward, an I/O error prevented reading a page that was required by the transaction.

What is Deferred transaction. BEGIN TRANSACTION. Using Deferred Transactions. Deferred Transaction Count. Deferred Transaction Views. deferred transaction count. deferred transaction costs. deferred state deferred call. using deferred transactions example. using deferred transactions package. creating a deferred transaction. corrupted transaction. corrupted database. corrupted file. corrupted database in sql server 2012. corrupted database in sql server 2008. corrupted database in sql server 2005. corrupted database in sql server 2000. What happens with my deferred transaction


Post a Comment