• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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?  
0
J4sstrom
Asked:
J4sstrom
1 Solution
 
Imran Javed ZiaCommented:
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
 
Imran Javed ZiaCommented:
Please try from following in Sql Management Studio in Object Explorer:

Your Server -> Management -> SQL Server Log
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Imran Javed ZiaCommented:
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:
My apologies for inadvertant abandonment.  Decision was made to scrap server and replace.  That said, no solution to issue was ever found.
0
 
J4sstromAuthor Commented:
Accepting not as solution, but as resolution.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now