Share via

sqlserver2019 port1433 Restart without cause

ysj 0 Reputation points
2023-12-04T01:40:36.0666667+00:00

No problem was found in the log

Windows for business | Windows Server | User experience | Other
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. RahulRandive 10,506 Reputation points
    2023-12-04T23:00:29.6933333+00:00

    Hi @ysj

    I think look like you would like to know the cause of restart.

    As recommended, it is necessary to examine the event log and error logs to identify the root cause.

    You may need to lookup the SQL Server ErrorLog file(s) for details-

    Viewing the SQL Server Error Log

    If no relevant details are found, you may need to configure usage and diagnostic data collection for SQL Server in case this issue occurs again

    You can configure Group Policy settings on the server to opt in or out of crash dump collection

    Please find detailed information in this document - https://learn.microsoft.com/en-us/sql/sql-server/usage-and-diagnostic-data-configuration-for-sql-server?view=sql-server-ver16#set-registry-subkeys-for-crash-dump-collection

    Thank you!

    Was this answer helpful?

    0 comments

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.