Can someone give me pointers where to look in order to debug why this fresh install of Windows Server 2008 R2 with an untweaked MS SQL-Server R2 which is serving just one ~5GB db to 2 clients crashes once a week?
(All updates applied, no other software running, no other roles. No Hyper-V, running on bare metal. Intel Core i5 660 @ 3,33 Ghz, 16GB RAM, 64bit Windows Server R2)
UPDATE:
I looked into the logs, filtered Windows>System logs for critical and errors only, found (translated into English):
ERROR: Service Control Manager; the service "SSPORT" could not be startet, file not found
CRITICAL: Kernel-Power
–these are the only severe looking things in this log, possibly unrelated. Nothing in Security logs, and in Application only MSSQL complaining about that it can't connect to the reporting server, right after restart (of which I read in the MS KB that it's normal after restart)
Best Answer
This sounds like a hardware issue. Try replacing the power supply. It could be something else, as well (weak capacitor on the motherboard?), but the power supply will be the easiest (and cheapest) place to start.