how to determine cause here ?

Our SQL Server was not pingable and the only thing in the Windows event log
that stands out is
The previous system shutdown at 2:31:24 AM on 9/20/2007 was unexpected.
How can I figure out root cause for why the SQL Server went down ? There is
nothing in the sql log too..
Thanks
Hi Hassan
The current SQL log will only be since the reboot have you looked in the
previous ones? Do you have any other events in the event log ie. was that
somehow cleared on reboot? If you do clear it, it is probably a bad idea to
so.
John
"Hassan" wrote:

> Our SQL Server was not pingable and the only thing in the Windows event log
> that stands out is
>
> The previous system shutdown at 2:31:24 AM on 9/20/2007 was unexpected.
> How can I figure out root cause for why the SQL Server went down ? There is
> nothing in the sql log too..
> Thanks
>
>
>