- Sql Server 2005 Windows Server 2003 64 bit 8 processors
- 3 volumes with at least 100 gigs free on each
I was adding an sql index for a table with millions of rows and the server shut down. Nothing in the event log other than the last shut down was unexpected. Upon restart the db is suspect and I take the steps to recover it. I'm running a dbcheck for about 30 mins then another shut down. This pattern is easily repeatable meaning that it has happened every time I've attempted it.
If I don't attempt to recover this db and let it sit the server doesn't crash otherwise. It ran for a week before I noticed the db was broken. Meaning, under regular load, this server doesn't crash. This isn't a prod system but for testing.
I'm guessing its overheating though nothing is telling me that. The server has not had heat issues in the past and it was designed with heavy duty heat sinks and has a good air flow.
I suppose it could be a faulty memory stick. I'll run a memory check in a moment.