Our SQL Server stops without any error messages or log messages, except a
W2K event log reading
The MSSQLServer service terminated unexpectedly. It has done this 6 time(s).
The following corrective action will be taken in 0 milliseconds: No action.
It then restarts about 20 seconds later and the NT event viewer always has
Windows could not save the registry settings in your user profile on its
first try because another program or service was editing them. Windows tried
again and saved them after 23 attempts.
I've found nothing in the MS Knowledge base or in other posts. Have traced
the server and not seen any particular query running when it happens.
Hardware works fine, no other errors or service problems. It only happens
where there is a moderate load on the server. (20-30 users)
Anyone have any suggestions?
Looking for troubleshooting help. Here's the software/hardware info.
SQL 7 SP2
1GB RAM 300-800MB to SQL
DELL 2400 DUAL 733 P3 w/RAID 5
Main database about 4GB
Plenty of hard disk space.