Good Morning All,
We seem to be having an issue with our ERP database server.
The server hardware is an HP ML370G5 server running dual quad core processors with 32 GB of RAM.
It is running Windows 2003 SP2 Enterprise edition with SQL 2005 SP2.
We have run memtest which came back clean, removed antivirus, patched, updated etc, but the server still intermittently locks up.
We have seen some HP patches with address similar circumstances and applied those but with no resolution. At first we thought it might be this;
We have done complete disk checks and everything comes back clean.
The one consistent is the issue always happens shortly after Report Scheduler completes successfully (Event ID 20010) and usually (but not exclusively) after a Log is backed up (MSSQL$SQL2005 event id 18625). Neither of these are errors (just information) in the log.
Does anyone have any ideas on a fix? Where to look next?