We quite often have to mount copies of our production SQL cluster to our UAT and development environments. The process is straightforward: Create a SMSQL snapshot, create a flexclone using that snapshot as the base, present the cloned luns to the UAT/DEV servers and mount the database.
Usually this works just as expected and the databases can attach to the server without any issues. However a couple of times, upon attaching the database to the SQL server we see the following:
Msg 1813, Level 16, State 2, Line 2
Could not open new database '**DBNAME**'. CREATE DATABASE is aborted.
Msg 3437, Level 21, State 3, Line 2
An error occurred while recovering database '**DBNAME**'. Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction (0:761111491). Fix MS DTC, and run recovery again.
For our UAT environment this is not an issue, we can simply create another snapshot and try again. What concerns me is that this has happened on our nightly backups and in a disaster event, there's a possibility SMSQL has not created an application consistent snapshot which we then are unable to use for disaster recovery.
Has anyone ever encountered this before?
All servers are SnapManager for SQL 5.1, Windows 2008 R2 SP1 and SQL 2008.
Thanks
