Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 2008 stops working every time I restart my computer

Posted on 2014-01-03
10
Medium Priority
?
902 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 25

Accepted Solution

by:
SStory earned 750 total points
ID: 39753790
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 27

Expert Comment

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

Author Comment

by:TimHudspith
ID: 39753805
Yes, Start Mode is Automatic.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39753818
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
ID: 39753834
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
 
LVL 26

Expert Comment

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

Expert Comment

by:13Shadow
ID: 39753953
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 43

Assisted Solution

by:Eugene Z
Eugene Z earned 750 total points
ID: 39757481
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
ID: 39761185
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 43

Expert Comment

by:Eugene Z
ID: 39761590
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

636 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