Hey Jim,
Thanks for the jab, very funny, well played. At first we thought the issue was hardware. But we ruled that out. The first reboot was on Cluster Server A. The second reboot was on Cluster Server B. The commonality is that it was the node with Prod business data on it that did the reboots. Our SQL servers are active/active. We have Prod and the system databases on one cluster resource, and the DV and PY databases on the other cluster resource. We generally try to use both sides of the cluster, but can run both cluster resources on the same node if necessary.
Other than a few entries in the event log, the issue is not logging anything for the infrastructure guys. These are high end HP servers with an auto-recovery feature. I spoke with our infrastructure director last night, they decided to turn off the auto-recover feature to see if they can capture some logs or screen dumps. So Ken, hopefully if (when) it fails again, we will have a blue screen to capture data from.
Hopefully we can get this fixed soon, because month-end closing is right around the corner.
Veggy - no it's not the daylight savings rule, that is set correctly.
Sebastion - we have the same virus scanning solution on hundreds of other servers, including fourty other SQL 2005 servers without the same issue. We think your last thought, the MS patches are the culprits.
Here are the patches we installed:
10/20/2009 Security Update for Windows Internet Explorer 7 (KB974455)
10/20/2009 Security Update for Windows Server 2003 (KB954155)
10/20/2009 Security Update for Windows Server 2003 (KB958869)
10/20/2009 Security Update for Windows Server 2003 (KB969059)
10/20/2009 Security Update for Windows Server 2003 (KB971486)
10/20/2009 Security Update for Windows Server 2003 (KB973525)
10/20/2009 Security Update for Windows Server 2003 (KB974112)
10/20/2009 Security Update for Windows Server 2003 (KB974571)
10/20/2009 Security Update for Windows Server 2003 (KB975025)
10/20/2009 Security Update for Windows Server 2003 (KB975467)
Gregg Larkin, MBA
North American JDE Systems Engineer