SQL Server 'Switching Off' for no reason!!
Posted on 2012-03-13
Hi there all,
I have a customer with a problem on one of their SQL servers where it keeps swithing off for no reason.
They have three SQL servers - all IBM 3650 rackmount machines with 3 x RAID1 mirrors and running Windows Server 2003 R2 and SQL Server 2005 and it is only this one machine that shows this problem.
We have replaced the hardware using a spare machine that is kept on site for this purpose and the same thing happens, although it did appear to be better for a short period.
All that seems to happen is that the machiine switches off - nothing in the Windows event viewer apart from an 'unexpected shutdown' event - this usually happens sometime during the evening but does happen randomly during the day as well.
From what I can see the O/S and SQL have all updates as does the IBM BIOS.
Would appreciate any pointers as to where I can look next as this is now 2 different servers doing the same thing but only with this one SQL application - the other 2 SQL servers are working quite happily. I cannot see any obvious hardware fault and the software company for this one application is saying there doesn't seem to be a problem with their side!
Any advice would be welcomed!