Real Time MS SQL Server Restart system Alert Template | Event Id: 1074

Опубликовано: 16 Январь 2024
на канале: MS SQL DBA Tech Support
321
15

Join this channel to get access to perks:
   / @mssqldbatechsupport  

Join the Telegram Group for the scripts and assistance:
https://t.me/+sDwstoLcYo9jMTdl

Hello Team,

We have received "System Has Rebooted" alert from the server Lenovo and

Below are our observation and summary of findings on the alert for Server Restart.

Hostname:Lenovo
Status of SQL Server Services: Online
Status of all User and system database: Online
Status of SQL Agent Jobs during restart of system: Successful
Status of High Availability Database : NA
Status of Resource if running on Cluster server: NA
Event Viewer Log for Restart of Server: (Windows log ID: 1074)
========================
Log Name: System
Source: User32
Date: 14-01-2024 02:43:26 AM
Event ID: 1074
Task Category: None
Level: Information
Keywords: Classic
User: LENOVO\Lenovo
Computer: Lenovo
Description:
The process C:\WINDOWS\Explorer.EXE (LENOVO) has initiated the power off of computer LENOVO on behalf of user LENOVO\Lenovo for the following reason: Other (Unplanned)
Reason Code: 0x0
Shutdown Type: power off
Comment:
=======================

Any reported error in SQL Server Error Log: No suspicious error recorded in the SQL error logs.
Playbook Referred: Yes
Solution: Permanent

Currently all the services are up and running fine, all database are UP and running on multi-user mode.

Hence we are closing this ticket.

Kindly let us know if any concerns.

Thanks & Regards
Harsha Reddy
MS SQL DBA TECH TEAM




You Can Also Download the scripts from below folder
https://drive.google.com/drive/folder...
We strongly believe there is always chance of betterment, so suggestions are most welcome.

Happy learning, and All the Best in your professional journey!

The journey of improvement is ongoing and never be an end.

#azuresql #azure #sqldba #sqlserverdba #sql #sqlserver #sqlserverdeveloper #performance #performancetuning #performanceoptimization #mssql #mssqlserver #mssqlserverdba

Thank you!
MS SQL DBA Tech Support
[email protected]


Смотрите видео Real Time MS SQL Server Restart system Alert Template | Event Id: 1074 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS SQL DBA Tech Support 16 Январь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 321 раз и оно понравилось 15 людям.