I've got an odd issue with a SQL 2012 cluster. The cluster itself uses FC shared storage, and generally works perfectly. The SQL service works, and failover occurs as expected.
The issue I have is that the inactive node occasionally tries to access the shared storage. This throws an eventlog error similar to:
MSSQLSERVER: 17058: initerrlog: Could not open error log file 'G:\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 3(The system cannot find the path specified.)
This error will sporadically occur between 8-12 times over a 3 second period and G: is one of the shared disks.
It looks like the inactive node is trying to start the service, and failing because it can't write to the shared storage, because it doesn't own it. What could be causing this?
0 Answers