Beberapa waktu lalu, database production mengalami down. SQL SERVER 2005 Service tidak bisa ngangkat. Berikut error log dari event Viewer:
--
Event Type: Error
Event Source: Service Control Manager
Description:
The SQL Server Agent (SQL2005) service depends on the SQL Server (SQL2005) service which failed to start because of the following error:
The operation completed successfully.
--
Event Type: Error
Event Source: MSSQL$SQL2005
Description:
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
--
Event Type: Error
Event Source: MSSQL$SQL2005
Description:
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
--
Event Type: Information
Event Source: Service Control Manager
Description:
The SQL Server (SQL2005) service entered the stopped state.
--
1 jam database mati. Tidak bisa up. Walau panik namun tetap tenang. Saya lakukan pengecekan di Google (prosedur wajib). Lakukan restart server sekali, tidak pengaruh, cek lagi di Google, utak-atik Surface Area Configuration, masih tidak ngaruh. Saya telpon teman, tidak ada solusi. Saya restart server lagi, tiba-tiba keajaiban terjadi, database = UP...
Aneh.
