Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
umesh
Starting Member
1 Post |
 Posted - 2008-02-22 : 02:11:27
|
| Currently i am using SQL server 2005. Since the begining i am facing sqlserver service shutdown problem. Normally it happens in every 2-3 days and sometimes happens twice a day. It halts all the banking operation. After starting MSSQL SERVER service, the system goes online.Following is the error message recorded in the event viewer.---------------SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart). ---------------Please tell me what steps i should take to resolve it.ThanksUmesh RaghubanshiKathmandu,Nepal |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-22 : 10:17:15
|
| Have you checked the SQL log in SSMS (Management > SQL Server Logs)? A new log file is created every time the service starts, so the most recent entries in the log file just before the crash may have some information. |
 |
|
|
|
|
|
SQL SERVER 2005 SERVICE SHUTDOWN