You need to ensure that all transactions can be recovered

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases. All updates for a given record are performed in a
single transaction. You need to ensure that all transactions can be recovered. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases. All updates for a given record are performed in a
single transaction. You need to ensure that all transactions can be recovered. What should you do?

A.
Call the RecoveryComplete method of the TransactionManager class.

B.
Call the EnlistDurable method of the Transaction class.

C.
Call the Reenlist method of the TransactionManager class.

D.
Call the EnlistVolatile method of the Transaction class.

Explanation:
Volatile resource managers cannot recovery from failure to complete a transaction in which they
were participating. To obtain a durable enlistment in a transaction, use the EnlistDurable method.
For more information on volatile and durable resources, as well as how to enlist a resource, see
Implementing A Resource Manager. For more information on how a resource manager responds to
commit notification and prepare the commit, see Committing A Transaction In Single-Phase and
Multi-Phase.
http://msdn.microsoft.com/en-us/library/ms149779.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *