Post reply

MSSQLSERVER service terminated unexpectedly

  • June 27, 2006 at 10:31 am

    #68322

    Hello

    We are running SQL Server 2000 EE SP4 with hotfix for AWE. Yesterday, SQL Server just stopped and restarted on one of our Servers with no errors in SQL Server error log, application and System log. Application log just says "The MSSQLSERVER service terminated unexpectedly". There is no dump also. How do you find out what caused this error to occur?

    Can we do something to capture the error before it happens again?

    Thanks

     

     

     

     

  • June 27, 2006 at 11:01 am

    #646137

    I would look at the server. Did it 'crash' also? Was there a power surge? Also, look at the 'previous' SQL Server error log. (Restarts create new logs). See what time the shutdown occured. What was happening during that time frame?

    -SQLBill

  • June 27, 2006 at 12:23 pm

    #646172

    Nope. Server didn't crash. When SQL Server restarted by itself, I see the new log created. SQL Server log does not say that it stopped or restarted, only Application log says "MSSQLServer service terminated unexpectedly".

  • June 27, 2006 at 12:57 pm

    #646183

    Did the event logs/application logs give any more information

     

     

    Mike

  • June 27, 2006 at 1:11 pm

    #646189

    There was nothing else in the Error , Application or System log.

    Thanks

    Taiyeb

  • June 28, 2006 at 9:48 am

    #646408

    Is this by chance running on a cluster?

     

  • June 28, 2006 at 1:53 pm

    #646476

    Nope. It's not a cluster.

  • June 28, 2006 at 6:42 pm

    #646530

    You say " I see the new log created". So it seems you only checked the new log....take a look at the previous log also. There will be more than one, the current one should say errorlog and the rest will have something else after the errorlog.

    -SQLBill

  • June 29, 2006 at 12:11 am

    #646552

    Was there a backup job running at the time of crach ?

    Check the backup job for errors (e.g. filecontention /directorycontention of the backupfiles may cause a servercrash with sql7)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • June 29, 2006 at 1:27 pm

    #646826

    I checked the previous error log also. It does not say anything. There was a differential backup completed 5 minutes before SQL Server restarted.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply