SQL Server Failover cluster instance upgrade failure issue from 2008 R2 to 2012

Today, one of my clients’ production environment was facing an issue with the failed upgrade of a SQL Failover Cluster Instance from SQL 2008 R2 to SQL 2012. They were trying the upgrade since a couple of days and it was failing with the below error TITLE: SQL Server 2008 R2 Setup —————————— The following…

0

SQL Server detected a DTC/KTM in-doubt transaction

Few days back, one of my clients’ faced an issue with their Availability group getting into the resolving state. On checking the logs found that the issue was due to a split brain scenario and as it was a business critical issue, we resolved the issue by restarting the SQL server services on the Secondary…

0