activo | asset management system

Monday, December 19, 2011

Keajaiban Restart 2 Kali


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.

Komentar Terbaru