26.2.10

"svchost (876) The database engine stopped" in sql server

SQL Server typical error:
Some times, Our sql server will get stopped frequently. On checking the event viewer, we will get the following error message "svchost (876) The database engine stopped".

If you got such an error message, check the following.
1. Goto run, type service.msc. You will get services console, check the sql server agent and sql server services. If its not running right click the services and start it.

2. Check for anti virus software, you should get exclusion from the antivirus.

3. Check for "Autoclose option" in the database. If you have option, its advisable to uncheck this option.

Happy Learning!!!

Regards,
Venkatesan Prabu .J

No comments:

Post a Comment