Real Time MS SQL Server Restart system Alert Template | Event Id: 1074
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]
Watch video Real Time MS SQL Server Restart system Alert Template | Event Id: 1074 online without registration, duration hours minute second in high quality. This video was added by user MS SQL DBA Tech Support 16 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 321 once and liked it 15 people.