kayaknya sudah jelas datafile nya berada di badblok/badsector Data error (cyclic redundancy check).) = Cacat Fisik LapHar_Data.MDF = Datafile yang sudah terattach di SQL Server
solusinya kayaknya memang: chkdsk /f c: atau scandisk c: /autofix /surface atau defrag ----- Original Message ----- From: ari susanto To: [email protected] Sent: Tuesday, September 12, 2006 10:43 AM Subject: Re: [indoprog-vb] Mohon Bantuan : SQL SERVER ERROR defrag & check HD lewat command prompt, defrag /f <drive>: CHKDSK -f <drive>: semoga berhasil. ari susanto kiss_me <[EMAIL PROTECTED]> wrote: se 7... mending pertama di check dulu hd nya..pake hd analyzer software .... saya juga pernah tuh ngalemin dan hasil nya memang ada bad sector .... smoga bermanpaat. Ade Aan Wirama <[EMAIL PROTECTED]> wrote: Error Level 24 itu umumnya masalah hardware, bisa jadi hddnya ada yg bad sector. Coba jalankan DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKALLOC, outputnya apa? bisa dipost disini? Kalo mau cara cepet, coba restore aja databasenya, tapi pastikan bahwa hddnya gak rusak/bad sector. Regards, Ade Aan Wirama Coding for Humanity --- Bagus Wicaksono <[EMAIL PROTECTED]> wrote: > Pada saat saya mengakses suatu database melalui > Query Analyzer, ataupun Enterprise Manager, muncul > pesan error berikut ini : > "Server: Msg 823, Level 24, State 2, Line 1 > I/O error 23(Data error (cyclic redundancy check).) > detected during read at offset 0x000000002a0000 in > file 'C:\Program Files\Microsoft SQL > Server\MSSQL\Data\LapHar_Data.MDF'. > > Connection Broken" > > Saya tidak bisa menghapus/mengedit data yg ada > didalamnya, dan saya juga tidak bisa melakukan query > terhadap database tersebut. > Mengapa pesan error tersebut bisa muncul ya, dan > bagaimana cara memperbaikinya agar data yg ada > didalamnya bisa diakses kembali... > > Terimakasih banyak atas pencerahan dan informasi > dari teman2 sekalian... > > Bagus W > > > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check > it out. > > [Non-text portions of this message have been > removed] > > > > Untuk berhenti berlangganan kirim email kosong ke : > [EMAIL PROTECTED] > > Bagi terjangkit virus lokal, zip virus tersebut > dan kirim ke [EMAIL PROTECTED], kami > akan membuat removalnya untuk anda. > Yahoo! Groups Links > > > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------- Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. [Non-text portions of this message have been removed] --------------------------------- Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. [Non-text portions of this message have been removed] ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.2/442 - Release Date: 9/8/2006 [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Bagi terjangkit virus lokal, zip virus tersebut dan kirim ke [EMAIL PROTECTED], kami akan membuat removalnya untuk anda. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indoprog-vb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
