Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server. We are using SQL version 2014 with availability replica group with 3 node running on window server 2016. 1 st primary replica at DC 2nd secondary replica at DC 2nd backup secondary replica at DR All availability replicas mode in Synchronous commit. On the window event log I found an error "The MSSQLSERVER service terminated unexpectedly", event id: 19019. What's the possible case of this error? Thanks!

Is your SQL Server on latest patch level? Run SELECT @@VERSION

The MSSQLSERVER service terminated unexpectedly

Suy Peang 91

Dear All SQL expert,

Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly?

Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server.

We are using SQL version 2014 with availability replica group with 3 node running on window server 2016.

All availability replicas mode in Synchronous commit.

On the window event log I found an error "The MSSQLSERVER service terminated unexpectedly", event id: 19019.

What's the possible case of this error?

Thanks!

MikeyQiaoMSFT-0444 3,190 Reputation points

2024-03-27T07:44:09.9766667+00:00

Hi，can you attatch the latest error log which locate in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG,It is also advisable to provide cluster logs from the failed cluster manager
Suy Peang 91 Reputation points

2024-03-27T08:26:45.93+00:00

Hi sir, Can I share private to you?
MikeyQiaoMSFT-0444 3,190 Reputation points

2024-03-27T08:32:19.4566667+00:00

Just attatch the file directly, but before doing so, please make the appropriate modifications to any sensitive data.