How to Auto Restart SQL SERVER when its crashed?
The possible reasons for SQL server crash are listed below 1 . What to do if the operating system crashed? For this, the solution is very simple. i. In PC start -> open Run, type “services.msc“. ii. In this find the SQL Services name (ex: SQL Server (MSSQLSERVER)) of the instance and then click Properties. iii. In properties window, select start type to Automatic as shown below 2. There could be situations where SQLServer is shutting down automatically due to a crash or an unexpected behaviour with SQL…
Read More