Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Inactive SQL node tries accessing Errorlog on cluster disk owned by other node Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 9:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 2, 2013 1:06 PM
Points: 1, Visits: 20
Hello,
Due to an operating system failure, I had to reinstall the Operating System (Windows 2008 R2 SP1) on node 2 of my two node failover cluster. I evicted the node and went on with reinstalling the OS. Once I patched windows, updated all drivers, joined to the domain, added iscsi, installed SQL by adding a node to a cluster, patched SQL to Sp1 and then to SP1 CU6, I did a failover. The failover went fine.

However, when I moved SQL back to the first node, I noticed that every 35 minutes I get the following error in the application log on my second node -

initerrlog: Could not open error log file 'J:\MSSQL10_50.SQL2K8\MSSQL\Log\ERRORLOG'. Operating system error = 3(The system cannot find the path specified.).

Being that the second node isn't active, it doesn't have access to that drive. I went through the scheduled tasks and there is nothing there.

I noticed that the first node does not give these errors when the first node is inactive.
Any thoughts?


Scott Drummond
@drummondsql on twitter
Post #1466789
Posted Wednesday, June 26, 2013 5:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 1,375, Visits: 2,667
Do you perhaps have any 3rd party software installed on the inactive node that requires SQL to be started? Maybe a 3rd party backup software that makes a connection to SQL Server?

Regards
Post #1467572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse