Distributed Transaction Coordinator (DTC) fully complies with Windows Backup and Restore functionality.
However, backup and restore applies only to the local computer resources. Therefore, if there are active transactions spanning different computers, transactional consistency cannot be guaranteed.
To avoid problems, make sure that there are no incomplete transactions during backup or restore operations under the following conditions:
- A computer is running as a remote DTC
coordinator
Use the following procedure "To determine if a computer is using a remote coordinator" to determine if the computer is using a remote coordinator. To resolve any incomplete transactions, use the following procedure "To view and resolve existing transactions."
- A computer has an application that is
participating in transactions spanning multiple computers
Use the following procedure "To determine if a computer is using a remote coordinator" on the computer where the application is running to determine the transaction coordinator for that computer. To resolve any incomplete transactions, use the following procedure "To view and resolve existing transactions" on the computer where the coordinator is running.
To determine if a computer is using a remote coordinator |
-
Open the Component Services snap-in.
-
Right-click the computer whose transaction coordinator settings you want to change (for example, My Computer), and then click Properties.
-
In the properties dialog box for the computer, click the MSDTC tab.
-
If the Use local coordinator check box is cleared, the computer name that is listed in Remote coordinator host name indicates the remote coordinator that is being used by the computer.
-
Click OK.
To view and resolve existing transactions |
-
Open the Component Services snap-in on the computer that is acting as the coordinator for transactions.
-
Double-click Computers, My Computer, Distributed Transaction Coordinator, and Local DTC, and then click Transaction List.
The list view displays all incomplete transactions.
-
To resolve an incomplete transaction, right-click the transaction, and then click Resolve. Select Commit, Abort, or Forget as necessary.