I have 2 Nodes of SQL Cluster running SQL 2012 Ent over Windows 2012 R2 and i don't know suddenly what happened the service is not coming online. Under Failover Cluster Mannager > Roles > SQL > Resource > SQL Server (instance-name) the status us Online Pending and then Failed.
Cluster have only below evetns;
- The Cluster service failed to bring clustered role 'SQL Server (instance-name)' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered role.
- Cluster resource 'SQL Server (instance-name)' of type 'SQL Server' in clustered role 'SQL Server (instance-name)' failed. Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
- Fault bucket , type 0 Event Name: Failover clustering resource deadlock Response: Not available Cab Id: 0
Problem signature: P1: SQL Server (instance-name) P2: SQL Server P3: ONLINERESOURCE P4: P5: P6: P7: P8: P9: P10: Attached files: These files may be available here: C:\ProgramData\Microsoft\Windows\WER\ReportQueue\Critical_SQL Server (instance-name)_217169f34c33c838a6522b285697633e938ebe_00000000_03a6e263 Analysis symbol: Rechecking for solution: 0 Report Id: 11f7e038-5f26-11e7-80fb-7a2f1397e813 Report Status: 4100 Hashed bucket:
Kindly suggest what could be wrong.