This morning we had a MTS (Microsoft Transaction Server) proces that locked a table in the database. It was running quite a while and stoppen and restarting the MTS service didn't solve the problem.
Killing the process didn't workted neighter so I had to stop and restart the sqlserver service.
Ofcourse the database server came up with the database marked suspect. At startup, the following error appeared :
Error recovering database 'xxx'. Could not connect to MSDTC to check the completion status of transaction (0:14122)..
Are there any other solutions then trying the sp_resetstatus and hoping for the best and if that doesn't work, restoring the databses ?