Windows Thread, SQL Server 2005 - Terminating without reason! in Technical; Our MIS developer server has Windows Server 2003 with a basic SQL Server 2005 install.
Recently it has been self ...
23rd April 2009, 11:14 AM #1
SQL Server 2005 - Terminating without reason!
Our MIS developer server has Windows Server 2003 with a basic SQL Server 2005 install.
Recently it has been self terminating the SQL services with the following error:
The SQL Server (instancename) service terminated unexpectedly. It has done this 1 time(s).
Any help? The error provides very little information!!!
23rd April 2009, 11:38 AM #2
Can you check the SQL server error logs for that instance and see if there's a little more detail in there?
23rd April 2009, 11:43 AM #3
Here is a recent event log from SQL Server agent. I recently went on a SQL course but am by no means an expert!
23rd April 2009, 11:52 AM #4
Check the account the SQL service is running under - it looks like a permission is being denied or the account is being prevented from running the service in some other way.
Does this happen at specific times of day? Any scheduled tasks which run at that time such as backups?
23rd April 2009, 12:24 PM #5
The SQL services seem to be running under NT AUTHORITY\NetworkService?
The past couple of days it seems to have occured in the 8 - 9am timeframe, we've checked the backup logs for today and the backup finish time does come close to when the error appeared - So the server is now in a higher priority in the backup schedule to see if the errors correlate with the backup finish time tomorrow.
For reference we use CA ArcServe
23rd April 2009, 12:31 PM #6
Does the backup include the SQL database?
23rd April 2009, 12:42 PM #7
The entire system state plus all volumes so I would presume so, yes.
Although we back up our Financial and CIS systems and those are both SQL 2005 without any huge issues? (Those were installed by 'professionals' though!)
23rd April 2009, 12:45 PM #8
Do you use the same backup method for those?
At a guess I'd say that the backup's locking the database, so the service promptly dies in a slow, painful way. It then tries to restart, gets access denied as the database is still locked.
Another thought, is the database set to single-user mode?
24th April 2009, 11:13 AM #9
I believe we use the same backup method for those yes.
The backup ran earlier last night and there were initially no problems earlier this morning, but the phone has just gone off and the service has gone again at 10am today (Totally clear of the backup schedule). So now I'm baffled.
Not sure how to find out if it is in single user mode?
Would installing the latest patches etc help or make the problem worse?
24th April 2009, 11:16 AM #10
Also today we are getting:
Timeout (30000 milliseconds) waiting for the SQL Server Agent (ISIS) service to connect.
24th April 2009, 11:35 AM #11
Have you got SQL Management Studio? In here it should state whether or not the database is in Single User mode.
If you've got full SQL Management Studio rather than the express version you could also use SQL Profiler to see what's going on when the service fails.
24th April 2009, 12:21 PM #12
There are several databases, all seem to in Multi User mode
We do have the full SQL Studio, but rather than using Profiler I have enabled the Include Exception Trace messages for SQL Agent in case that will provide any clues the next time it fails?
Thanks for all your help so far, I do appreciate it!
24th April 2009, 12:28 PM #13
Hopefully that should provide something, yep.
28th April 2009, 12:53 PM #14
Well the extended logging provided no more useful information than before
By techie08 in forum Windows Server 2000/2003
Last Post: 13th February 2009, 12:06 AM
By ahunter in forum Virtual Learning Platforms
Last Post: 31st October 2008, 01:19 PM
By philserre in forum MIS Systems
Last Post: 14th October 2008, 09:44 PM
By ICTNUT in forum Windows
Last Post: 7th July 2008, 10:53 AM
By zag in forum MIS Systems
Last Post: 21st November 2007, 09:46 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)