Monday, March 19, 2012

MSSQLServer Service terminated unexpectedly MS-SQL 2000 with SP4

MSSQLServer service terminated unexpectedly

We are running SQL Server 2000 with SP4. This server has been running for the past six months with no SQL server problems. A Max of 10 users have access to the application running on this server.

The Event Viewer Log shows the
Source: MSSQLServer
Category: (2)
Type: Error
EventID: 17052
Description: The MSSQLSERVER service terminated unexpectedly.

No other error messages were seen in the SQL server log or windows event viewer.
The time when it terminated was not during peak load/activity.

The server is Windows 2003 with SP1. Any help would be appreciated.Are there any *.mdmp or *.txt files in the \mssql\log directory where the errorlogs reside?|||Sorry for my late response. There are a few mdmp and txt files in the log directory but all the log files have dates prior ( probably couple of months old file) to the day the crash occurred.

No comments:

Post a Comment