December 31, 2002 at 8:13 am
When our SQL cluster (active/passive) failed over to Server 2 SQL stopped writing to the error log until it failed back to Server 1. Does anyone know how to configure this so both SQL Server write to the error log?
December 31, 2002 at 8:57 am
Which error log were you looking at, and on what server? SQL Server, SQL Server Agent, Windows Event Logs?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 31, 2002 at 9:01 am
sounds like the error log needs to be included in the cluster group so both servers have access to it. Did you check both nodes to see if both had their own error logs?
Wes
December 31, 2002 at 9:33 am
I am using 2000. The SQL Server error logs are missing. SQL is only writing to the error log when it is on Server1. After fail over to Server2 no SQL Server logging happened that I can see. All I see when failed over on Server2 is the same SQL Server error logs from Server1. I have no idea what SQL did for about 14 hours last night but I know it was running.
quote:
Which error log were you looking at, and on what server? SQL Server, SQL Server Agent, Windows Event Logs?K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply