DBA - DESCRIPTION: An error occurred while recovering database 'Test_Database'. Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction (7:947605711). Fix MS DTC, and run recovery again.

 While we are getting the below error message during the database refresh activity, in this case data database went into suspect /recovery pending. 

DESCRIPTION:    An error occurred while recovering the database 'Test_database'. Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction (7:947605711). Fix MS DTC, and run recovery again.

we need to follow the steps below to bring the database online. 

This will mark all the MSDTC transactions as failed and allow you to start the database. It's a better idea to use backup/restore to refresh the database, though

Step 1: Stop the post refresh job

Step 2: Run the following command

sp_configure 'in-doubt xact resolution',2  

GO

RECONFIGURE

GO

 Step 3: Take the database offline and make it online. 

Step 4: Run the below command

sp_configure 'in-doubt xact resolution',0

GO

RECONFIGURE

GO

Step 5: Run the post refresh job