+ Post New Thread
Results 1 to 14 of 14
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 ...
  1. #1

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22

    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!!!

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    Can you check the SQL server error logs for that instance and see if there's a little more detail in there?

  3. #3

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    Here is a recent event log from SQL Server agent. I recently went on a SQL course but am by no means an expert!
    Attached Images Attached Images

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    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?

  5. #5

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    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

  6. #6

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    Does the backup include the SQL database?

  7. #7

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    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!)

  8. #8

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    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?

  9. #9

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    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?

  10. #10

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    Also today we are getting:

    Timeout (30000 milliseconds) waiting for the SQL Server Agent (ISIS) service to connect.

  11. #11

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    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.

  12. #12

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    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!

  13. #13

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    112
    Hopefully that should provide something, yep.

  14. #14

    Join Date
    Jan 2007
    Posts
    965
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22
    Well the extended logging provided no more useful information than before

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server 2000/2005
    By techie08 in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 12th February 2009, 11:06 PM
  2. Moodle & SQL Server 2005
    By ahunter in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 31st October 2008, 12:19 PM
  3. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 08:44 PM
  4. SQL Server 2005 Backups Problem
    By ICTNUT in forum Windows
    Replies: 0
    Last Post: 7th July 2008, 09:53 AM
  5. Sims SQL 2005 upgrade on a new server?
    By zag in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 08:46 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •