SQL Server service was terminated unexpectedly

• sqlguru

  SSC-Addicted

  Points: 471

  More actions

  April 29, 2022 at 4:42 pm

  #4024334

  Looked into the SQL Server Error logs coudn't find the reason why the SQL server service was terminated.

  Windows event view shows that SQL Server service terminated unexpectedly. It has done this 1 time(s). Event id:7034.

  So I looks all those error logs but prior to this error 7034 I could not find any other issues. It smells a host memory issues over committing.

  However, when this happened  it failed over to the secondary node. So not sure the cause for sql service terminated unexpectedly. If it's a standalone then to resolve this I would change the recovery actions for services under the recovery tab. But for the availability group do you advise anything needs to be done if ever this happens again?

   

   

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  April 30, 2022 at 5:10 pm

  #4024781

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.