Link to home
Start Free TrialLog in
Avatar of TimHudspith
TimHudspith

asked on

SQL Server 2008 stops working every time I restart my computer

Every time I restart my PC I find that SQL Server Services in SQL Server Configuration Manager has reset SQL Server (SQLEXPRESS) to the 'Stopped' state.
ASKER CERTIFIED SOLUTION
Avatar of SStory
SStory
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Shaun Kline
Shaun Kline
Flag of United States of America image
Have you checked the Services control panel to determine if the Startup Type is set to Automatic?
Avatar of TimHudspith
TimHudspith

ASKER

Yes, Start Mode is Automatic.
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image
Check the System and Application logs to see if there are any messages related to the SQL Server startup.
Avatar of SStory
SStory
Flag of United States of America image
Did you see if you are running out of resources as the article I posted mentioned? Is it causing the machine to shutdown and disable for this reason?
Avatar of tigin44
tigin44
Flag of Türkiye image
can you post the sql server start up log...
Avatar of 13Shadow
13Shadow
Check that the recovery response is set to Restart the Service and change the Restart the service after to 3 minutes (under the service properties Recovery tab).  Maybe it tries starting too soon and there are no resources available.
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TimHudspith
TimHudspith

ASKER

Strangely, this hasn't happened the past few days (this is SQL Server 2008 on Windows 7). I looked at the Windows event viewer and SQL Server logs - I'm not sure what the exact message is that I should be looking for but nothing stood out. As for setting the service recovery to "first failure restart 1" or 2, where do I do this?
Avatar of EugeneZ
EugeneZ
Flag of United States of America image
buy more memory, check what can you uninstall to free resources, check  startup PC options- what services on startup can be "unchecked" see above post-recommendations .
also make sure you have installed MS Critical Updates and Running periodically Anti virus on your PC.

service recovery:

Start->Run-> type there  services.msc->  find SQL Server (SQLEXPRESS) -> right click -> properties-> Tab recovery -> set "First Failure"  to "Restart service"  etc

-> OK