This is a discussion on Server Reboot within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I have a server running Windows 2000 Advanced and Sql Server. The systems runs fine throughout the day ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, I have a server running Windows 2000 Advanced and Sql Server. The systems runs fine throughout the day but reboots at night, somtimes multiple times. The event log has a message that reads "The previous system shutdown at X:XX PM was unexpected." Any ideas? Paul |
| |||
| "Paul" <paul_b_backer@yahoo.com> wrote in message news:1111502788.362885.189240@g14g2000cwa.googlegr oups.com... > Hello, > I have a server running Windows 2000 Advanced and Sql Server. The > systems runs fine throughout the day but reboots at night, somtimes > multiple times. The event log has a message that reads "The previous > system shutdown at X:XX PM was unexpected." > > Any ideas? > > Paul > Not really - without more information, the best you can do is try to gather some extra clues. Is there anything unusual in any log file before the shutdowns, are there any jobs scheduled in Windows or MSSQL which coincide with the shutdowns, have you run hardware diagnostics, did you upgrade any drivers recently, etc. Simon |
| |||
| Paul napsal(a): > Hello, > I have a server running Windows 2000 Advanced and Sql Server. The > systems runs fine throughout the day but reboots at night, somtimes > multiple times. The event log has a message that reads "The previous > system shutdown at X:XX PM was unexpected." > > Any ideas? Is the server on a UPS? Mark |
| ||||
| Paul-- This may or may not pertain...I run SQL Server 2000 on a Dell Poweredge 2500 that exhibited the same behavior. The box has redundant power supplies and apparently some condition in their interaction forced random hard re-boots, mostly during the night. I don't know the technical characteristics of the solution, but unplugging one of the power supplies fixed the intermittant rebooting. The loss of redundancy seemed a small price to pay for the uninterrupted up-time. It's been working fine for over a year. Hope this helps in your case. |