Solved

SQL Server 2008 Database some time down

Posted on 2014-01-17
5
492 Views
Last Modified: 2014-01-19
Hi, Expert can you tell me why our sql server 2008 some time down, then need to  restart it  again , again ?
0
Comment
Question by:Asrar Azmi
5 Comments
 
LVL 35

Expert Comment

by:David Todd
ID: 39790298
Hi,

Okay, if you have restarted SQL, can you look for the log file called ErrorLog.1 It is in the log folder in the instance directory.

The last few lines should show the shutdown. What is above that.

HTH
  David

PS It is fairly hard to understand what you are trying to say about what SQL does that you then need to restart it.

Do check that databases are on autoclose.
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39790420
Please ensure that the services of Sql server are automatically started. You need to go to

services.msc

to check these.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39790894
Hi

For SQL 2008, use SQL Configuration Manager instead of services app, especially when changing the account SQL and Agent run under. Config Manager also changes some permission necessary for SQL - services doesn't do that.

Regards
  David
0
 
LVL 40
ID: 39790943
You might have an application running in your environment that stops the server.

Personally, because I use my development computer for other purposes and need a lot of resources for these, I sometimes open and close the server through the application as needed during development. If that code goes into production, it can end up doing the same on the production server.
0
 
LVL 5

Accepted Solution

by:
rk_india1 earned 500 total points
ID: 39791117
The SQL server service can be down for many reason so we have to determine the facts to verify the Event viewer application  and system error log . I am strongly suggest to check the SQL server error log also. Please check the database server version by the command
Select @@version  and need to apply the latest SQL server service pack. it is my assumption it could be memory leak issue. Please apply the latest service pack cause lots of bugs are automatically fixed by the service pack.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

813 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

10 Experts available now in Live!

Get 1:1 Help Now