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]> > > > 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] 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/
