iya mas, dua2 nya ane pindahin On Mon, 14 Apr 2008 09:51:13 +0700, Noe <[EMAIL PROTECTED]> wrote:
> Coba bantu ya..., btw file sql server kan ada 2 : ".mdf" dan ".ldf". > apa dua2nya juga dah dipindahin. klo mdf aja yang dipindahin, ya jelas > g bisa. harus ada ldf - nya juga. > > semoga membantu > > --- In [email protected], "Sodik Ihwan" <[EMAIL PROTECTED]> > wrote: >> >> 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 >> > > -- 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/
