Sql-server – The SQL Server (MSSQLSERVER) service terminated unexpectedly. Event ID: 7034

sql-server-2016windows-server

Unable to find the cause why the SQL Server Service was Terminated Unexpectedly? (Event ID: 7034)

I looked into the SQL Server Error Logs but could find the reason about why the SQL Server service was terminated.

So check the windows event Viewer and I found the following error msg:

Event Message : The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s).

Error Event Id : 7034

Since last night my SQL server service is terminating with the this error.

This service terminates and restarts automatically and sometimes doesn't restart we have to manually start it again.

Version Details:
Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Standard Edition (64-bit)

OS: Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hyper-visor)

Best Answer

Error Event Id : 7034

Service Control Manager (SCM) stops services and driver services. It also reports when services terminate unexpectedly or fail to restart after it takes corrective action.

How to Resolve

Change the recovery actions

To resolve this issue, change the recovery actions that the Service Control Manager (SCM) will take when a service fails. To perform this procedure, you must have membership in Administrators, or you must have been delegated the appropriate authority.

To change the recovery actions for a service:

  1. Open the Services snap-in by clicking the Start button, Control Panel, and Administrative Tools, then double-clicking Services. Note: For Windows Vista, use the Classic View display option in Control Panel to see the Administration Tools.

  2. In the details pane of the Services snap-in, right-click on the name of the service you want to stop and select Properties.

  3. Click the Recovery tab and specify the recovery actions for the service (for example, restart the service or the computer, take no action, or run a program).

For your further ref Here and Here

Related Question