Our windows 2000 member server has been locking up about 4 times a week. It always happens at night when no one is in the office working on the database and it does not happen at any consitant time. No backup jobs or SQL agent jobs are running most of the times that it locks up. Times range from 6:00 pm until 8:25 am the next day. When I come in, I find that the computer is turned on, but most of the time the screen will not come on when moving the mouse and I am not able to ping it from another computer. The only thing that that shows up in the event veiwer at all is "The previous system shutdown at 'time' was unexpected." The time is always long before I hit the reset button. I have not been able to find any consitancy in when the server locks up. Does anyone have a suggestion as to how I can find the problem?
Thanks,
Michael
Thanks,
Michael