Berarti partisi tsb berisi file MDF dan LDF? Wah. Not according to the best practice :-) dimana kedua file tsb harus dipisahkan secara physical untuk tujuan restore plan yg gua kasih tadi.
Wish you goodluck d Halomoan 2010/6/1 ali dharmala <[email protected]> > > > Masalah utamanya,karena partisi dari MDF SQL Server nya itu ternyata hilang > saat restart server..saya juga kaget,krn action nya hanya restart server > saja tetapi partisi data hilang. > > regards > > KA 95 > > --- On Mon, 5/31/10, Halomoan Chow <[email protected]<halomoan%40gmail.com>> > wrote: > > > From: Halomoan Chow <[email protected] <halomoan%40gmail.com>> > > Subject: Re: [BinusNet] Recovery SQL Server MDF > > To: [email protected] <binusnet%40yahoogroups.com> > > Date: Monday, May 31, 2010, 10:19 PM > > Hi Ali > > > > Kalo MDF corrupt, masih ada kemungkinan di-recover > > databasenya lewat LDF > > file. > > Contoh scenario: > > > > Day 1. DB Full backup > > Day 2. DB Log backup > > Day 3. MDF corrupt sehingga perlu dilakukan restore dan > > tidak ada backup log > > hari ini. > > > > Berarti restore-nya sampe Day 1 dan Day 2. > > Lalu cara untuk restore sampe Day 3 adalah extract log > > terakhir dari LDF > > dengan tips: lakukan backup DB Log backup seperti biasa > > tapi dengan option > > NO_TRUNCATE. Tapi syaratnya DB instance harus up ato bisa > > di-startup untuk > > lakukan backup. > > > > Kalo disimpulkan, kondisinya seperti ini: > > > > Day 1. DB Full backup > > Day 2. DB Log backup > > Day 3. MDF corrupt sehingga perlu dilakukan restore dan > > tidak ada backup log > > hari ini. > > Day 3.1 DB Log backup with NO_TRUNCATE (with DB instance up > > and running) > > Day 3.2 Restore Day 1, Day 2 dan Day 3. > > > > Semoga membantu. > > > > Halomoan > > > > 2010/6/1 ali dharmala > > <[email protected]<to_ali_dharmanto%40yahoo.com> > > > > > > > > > > > > > Dear prens.. > > > > > > mo tanya ni... > > > ada cara recover MDF yg corrupt ga yah selain > > menggunakan third party ? > > > > > > dan gak ada backup krn backup otomatisnya gagal... > > > > > > mohon pencerahan dari suhu2 SQL Server... > > > > > > best regards > > > > > > KA 95 > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > > > "We cannot all do great things.But we can do small things > > with great love." - Mother Teresa > > --------------------------------------------------------- > > > > BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan > > Moderator BinusNet : Suryadiputra Liawatimena & Surya > > Iskandar > > > > Stop or Unsubscribe: send blank email to > [email protected]<binusnet-unsubscribe%40yahoogroups.com> > > Questions or Suggestions, send e-mail to > > [email protected]<binusnet-owner%40yahoogroups.com> > > > > Yahoo! Groups Links > > > > > > > > [email protected]<binusnet-fullfeatured%40yahoogroups.com> > > > > > > > > > [Non-text portions of this message have been removed] ------------------------------------ "We cannot all do great things.But we can do small things with great love." - Mother Teresa --------------------------------------------------------- BinusNet founded on Dec 28, 1998 Owner : Johan Setiawan Moderator BinusNet : Suryadiputra Liawatimena & Surya Iskandar Stop or Unsubscribe: send blank email to [email protected] Questions or Suggestions, send e-mail to [email protected] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/binusnet/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/binusnet/join (Yahoo! ID required) <*> To change settings via email: [email protected] [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/
