Thx Mas, uraiannya lengkap, tapi sayangnya kondisi saat ini file mdf tsb bukan dalam posisi suspect. jadi waktu itu engine nya ane matiin trus file nya ane pindahin ke folder lain. nah pas mo di attach lagi sama sekali tidak bisa. anyway, Thx a lot mas, salam, sodik On Thu, 10 Apr 2008 08:14:44 +0700, wiltek.ghozali <[EMAIL PROTECTED]> wrote:
> Hm... SQL Server memang sensitif dengan mati listrik. > Ini ada kutipan solusi dari web tetangga : > > http://www.nigelrivett.net/ > > -- Recover a corrupt database > Author Nigel Rivett > > The first step is to attach the database as suspect > Create a database with an mdf of the same size as the old one > stop the server. > Copy the corrupt mdf over the newly created one. > Restart the server - the database should be suspect. > > Get the server to retry recovery > Reset the suspect flag > this can be done by executing sp_resetstatus 'mydbname' > or by > update master..sysdatabases SET status = status ^ 256 where name > = 'mydbname' > Restart the server > > If the database is still suspect set it to emergency mode > This will be the case for torn pages - if you get a torn page error > go straight to this step. > update master..sysdatabases set status = 32768 where name = > 'mydbname' > (for v7 I believe it was update master..sysdatabases set status > = -32768 where name = 'mydbname') > > The database should now be in emergency mode and allow you to access > the data. > > The data should now be transferred to another database via dts, bcp > or queries (I prefer bcp native format). > You will get an error when trying to access the corrupt data but > should be able to access all the rest of the data. > Use indexes to access data around the corrupt pages. > > To allow the above commands to work you will have to allow updates > to system tables > Sp_configure 'allow updates', 1 > Reconfigure with override > > Remember to set it back afterwards > > > semoga membantu. > > Sodik Ihwan wrote: >> Dear All, >> Mohon bantuannya, kemaren kompi yg ada ms-sql server nya ndak sengaja >> kecabut kabel powernya ama orang yg lg benerin listrik, stelah itu >> database di ms-sql nya jadi suspect. >> ane udah coba beberapa cara tapi belum ada yg berhasil, terakhir waktu >> file .mdf mo di attach lagi muncul error message >> >> Microsoft SQL-DMO (ODBC SQLState: HY000) >> error 823: I/O error (torn page) detected during read at offset >> 0000000000000000 in file 'D:\KerjaanGW\DatabaseGW.MDF'. >> >> Mohon bantuan gimana caranya supaya bisa kembali normal, soale database >> kerjaan kantor. >> >> Thx All. >> sodik >> >> > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Send instant messages to your online friends http://asia.messenger.yahoo.com ------------------------------------ Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahana.programmer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Programmer-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/
