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.

Kategori

info (205) foto (133) komentar ga penting (128) fotografi (123) Technology (104) Kantor (95) website (88) blog (84) Jakarta (78) comic strip (75) bisnis (71) karir (51) suara hati (51) senda-gurau (50) wisata (38) Bekasi (37) Internet (34) manajemen (31) kuliner (22) selebritis (21) soccer (21) Navision (20) iklan (14) kasus (14) sql server 2005 (13) buku (11) Greeting (10) movie (10) komik strip (9) novel (9) programming (9) televisi (9) Banjir (8) VCD/DVD (8) kopi (8) Vanessa (7) billiard (7) hypermarket (7) bogor (6) kesehatan (6) rumah (6) old document (5) Terios (4) basket (4) guru (4) Axapta (3) bioinformatika (3) azure (1)

My Instagram