tony28 (3/27/2014)
Ok Now I will do log, after finish I will send..do you think that is good this setting from your experience ? Auto restart SQL Server if it stops unexpectedly
I am thinking about this and maybe it is better that SQL server will be restart than frozen or something.
True. But it's good to document the setting so that you are aware of that and will help you with troubleshooting in the future.
http://technet.microsoft.com/en-us/magazine/gg313742.aspx
And please can you explain me something ?
SQL Server may stop unexpectedly due to different reasons :
Memory leaks from a process within the SQL Server memory space, such as from an extended stored procedure or from OLE automation.
and so is not missing the problem with Failover Clustering here ? Because you said 3 reasons, but from this log I see that problem was with Cluster.
Thank you.
I was mentioning about the possible reasons for that SQL server failure. And they are not the only reasons. Could be something else too ..
Check this for more info Memory Leaking
http://mssqlwiki.com/2012/12/04/sql-server-memory-leak/
Cluster Log could be helpful in finding the actual reason.
--
SQLBuddy