This is what happened ..
SQL Server stopped with following error message :
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 21. 3. 2014 18:08:39
Event ID: 1069
Task Category: Resource Control Manager
Level: Error
Keywords:
User: SYSTEM
Computer: NameOfServer
Description:
Cluster resource 'SQL Server' of type 'SQL Server' in clustered role 'SQL Server (MSSQLSERVER)' failed.
Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.
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.
Ending the sqlservr.exe process directly, such as from the Process tab on the Task Manager or with a program such as kill.exe from the Windows Resource Kit.
Some types of unhandled access violations.
Then SQL Server Agent got stopped ..
Date 3/21/2014 6:08:39 PM
Log SQL Server Agent (Archive #2 - 3/21/2014 6:08:00 PM)
Message
[131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
And later the message was ...
Log Name: System
Source: Service Control Manager
Date: 21. 3. 2014 18:09:37
Event ID: 7034
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: NameOfServer
Description:
The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s).
This error message will be logged if SQL Server has been restarted by SQL Server Agent.
SQL Server Agent will only auto restart SQL Server if SQL Server stopped for some unexpected reason other than an explicit stop command from a user or application, and if the Auto restart SQL Server if it stops unexpectedly option is selected in SQL Server Agent properties. During the restart of SQL Server, SQL Server Agent will write this message to the application event log on the computer hosting SQL Server.
You need to check in SQL Server Agent properties in SSMS whether the following option has been enabled. Also check if SQL Server Agent has local admin rights on the box.
Auto restart SQL Server if it stops unexpectedly
--
SQLBuddy