The MSSQLSERVER service terminated unexpectedly

Suy Peang 91 Reputation points
2024-03-27T05:07:01.8566667+00:00

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,836 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,926 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
98 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 44,736 Reputation points
    2024-03-27T06:38:00.8+00:00

    Is your SQL Server on latest patch level?

    Run

    SELECT @@VERSION
    

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.