SQL instances stopping for unknown reason

Hello!

I am running a Windows Server 2003 box as a Terminal Server.  Several programs installed utilize a SQL 2005 instance (Backup Exec, Act, several CCH tax products).  Randomly throughout course of a day, and sometimes in middle of the night, all the instances stop.

This can happen several times a day, or not for days at a time.  Going into Services and selecting Start for each gets everything back online, so nothing seemingly too major occured, they just stopped.

Looking in the event log has been no help as there does not appear to be any errors happening in any of the logs that coincide with the instances shutting down.  As there are no obvious errors, it is also very difficult to determine when exactly they shut down as opposed to when somebody noticed they did.  

Anybody have any suggestions of where to begin looking for clues in the system?  
J4sstromAsked:
Who is Participating?
 
J4sstromConnect With a Mentor Author Commented:
My apologies for inadvertant abandonment.  Decision was made to scrap server and replace.  That said, no solution to issue was ever found.
0
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
Please also cross check the SQL Log
0
 
J4sstromAuthor Commented:
When I looked through the various SQL logs, they all seemed to be detailing startups, not listing what casued the stoppage prior to being restarted.  I am looking in:

C:\program files\microsoft SQL server\MSSQL.x\MSSQL\Log
- x represents various instances 1-4

Correct place?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
Please try from following in Sql Management Studio in Object Explorer:

Your Server -> Management -> SQL Server Log
0
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
also check if you have latest sp for sql server 2005?
0
 
J4sstromAuthor Commented:
I only hadve a copy of SSMS/express.  The Express version does not give option to view as I understand it.  Which takes me back to viewing these files in Notepad, but at least I was looking in the right place.

Anyway, what should I be looking for?  Since they all seem to start at instance start-up and don't say much after that.

Also, the server is as up to date as I can have it, I believe anyway.  Will try to find SP level of installed 2005 SQL to be sure.
0
 
J4sstromAuthor Commented:
SMS is showing the instance versions as 9.0.4053?
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure the time what process is running. and check the code for that process(es).
0
 
fjkaykr11Commented:
- Do any other services stop and have to be restarted as well?
- Are there any erors related to the Backup Exec jobs /  Do the backups complete succesfully?

 
0
 
J4sstromAuthor Commented:
Accepting not as solution, but as resolution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.