InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:50:51 GMT20http://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxcan you dump out the sql, windows and cluster logs into a zip file and attach to the post, might be worth a second (or many) pair of eyes looking over them.Thu, 27 Sep 2012 01:43:13 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxin cluster log nothng found same error as follows: Cluster resource 'SQL Server' in Resource Group 'SQLVS01' failed.Thu, 27 Sep 2012 01:19:53 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxno, automatic update is turnedoff..Thu, 27 Sep 2012 01:19:13 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxYou should also look at the cluster events in the cluster manager.Wed, 26 Sep 2012 15:36:40 GMTbenjamin.reyeshttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspx[quote][b]Zeal-DBA (9/26/2012)[/b][hr]how do we check if it is enabled or not?[/quote]go to control panel--> windows updates-->check if you have enabled itWed, 26 Sep 2012 11:57:27 GMTSapenhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxhow do we check if it is enabled or not?Wed, 26 Sep 2012 11:00:04 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxEnsure that you have no automatic updates scheduled on your servers.Wed, 26 Sep 2012 09:55:49 GMTSapenhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxThat isn't good.Look at the SQL Server log as the previous poster statedAlso look at the Windows Application and system log. There has to be more detail there.Wed, 26 Sep 2012 08:13:40 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxwhats in the SQL logs around the same times?Mon, 24 Sep 2012 08:26:54 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxi found following msgs in windows logCluster resource 'SQL Server' in Resource Group 'SQLVS01' failed.Timeout (30000 milliseconds) waiting for a transaction response from the DWMRCS service.Timeout (30000 milliseconds) waiting for a transaction response from the Netman service.The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop control.The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has done this 4 time(s).The SQL Server (MSSQLSERVER) service was successfully sent a stop control.The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s).The SQL Server (MSSQLSERVER) service was successfully sent a start control.Mon, 24 Sep 2012 07:55:10 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxCheck the windows logs, check the SQL server logs, they should contain the information about who/what/where/why/when restarted the SQL service.Mon, 24 Sep 2012 07:42:16 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1363485-391-1.aspxhello experts,in my production server sql service restarted unexpectedly, the concern teams are asking for root cause analysis doc for that, what is the best way to troubleshoot why get restarted and who restarted it.please helpMon, 24 Sep 2012 07:37:44 GMTZeal-DBA