Solved

SQL Server 2008 stops working every time I restart my computer

Posted on 2014-01-03
10
758 Views
Last Modified: 2014-01-10
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.
0
Comment
Question by:TimHudspith
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 25

Accepted Solution

by:
SStory earned 250 total points
Comment Utility
The following discussion talked of a similar issue. They said: "it appears the cause was due to the servers resources being reduced to zero and when that happened it sometimes crashed SQL server"
(source: http://stackoverflow.com/questions/3227249/sql-server-2008-r2-express-service-stopping-on-server)
0
 
LVL 25

Expert Comment

by:Shaun Kline
Comment Utility
Have you checked the Services control panel to determine if the Startup Type is set to Automatic?
0
 

Author Comment

by:TimHudspith
Comment Utility
Yes, Start Mode is Automatic.
0
 
LVL 52

Expert Comment

by:Carl Tawn
Comment Utility
Check the System and Application logs to see if there are any messages related to the SQL Server startup.
0
 
LVL 25

Expert Comment

by:SStory
Comment Utility
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?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 26

Expert Comment

by:tigin44
Comment Utility
can you post the sql server start up log...
0
 
LVL 3

Expert Comment

by:13Shadow
Comment Utility
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.
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
Comment Utility
what is your OS?
if win7/2008
set service to Start Mode is Automatic (delayed start)
and set the service recovery "first failure restart 1" or 2

also make sure you have installed a fresh service pack for Sql server \os
--
BTW: what sql  version do you have?  

more - you need to check event viewer related errors

and as per above post -- you may need  more Ram\NEW pc
Possibly uninstall some apps
check startup apps
run start->run-> msconfig to see hat can be disabled on startup
0
 

Author Comment

by:TimHudspith
Comment Utility
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?
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now