Share via

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 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.
SQL Server | SQL Server Transact-SQL
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,611 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.