The error in the system log is:
Event ID 7024
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
There are also errors in the application log. They are:
Event ID 17058
initerrlog: Could not open error log file 'R:\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 3(The system
cannot find the path specified.).
In looking through the log, these have happened on a previous reboot. I
just missed them at the time.
The primary node continued to run fine and when I fail over to the stand by,
it does so successfully and the mssqlserver service starts successfully then.
Is this a problem or is it normal for the node that does not have access to
the shared resource?
Thanks
By setting the services to Manual startup this error message will go
away.
Denny
Tony
Denny
Also, even if the services are Manual, there are times you may see that
error. At least, it happened to me. Typically, on retry, the instance would
come up fine.
Linchi
What is strange is this is happening only on one and only one node
Med