Saya cuma tau teorinya kira2 begini (seingatnya aja ya bozz - ini juga belom pernah coba langsung, cuma pernah diterangin aja) : Misal datanya hilang jam 12 siang. Sekarang jam 13.00. Buka Enterprise manager backup data lognya (TRN nya) backup datanya (full backup). restore data, tapi lihat ada option "point in time restore". Kita bisa restore data ke waktu yg kita inginkan. Tapi kalo ga salah harus backup transaksinya dulu (jangan langsung full backup)
PS : tidak boleh ada user yg connect. Mungkin cari2 juga ke google, jadi step2nya lebih yakin. Selamat berjuang :) Liung's www.apktntajd.com (Ape Kate Ente Aje Deh!) ----- Original Message ----- From: muhammad Taufiq To: [email protected] Sent: Friday, July 27, 2007 1:22 PM Subject: Re: [Programmer-VB] Undo drop tabel di SQL server klo datanya belum di backup gimana...coz data yang masuk ke dalam tabel tersebut sudah banyak sekali.. ----- Original Message ---- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, July 27, 2007 11:20:03 AM Subject: Re: [Programmer-VB] Undo drop tabel di SQL server Restore dari backup :D Liung's www.apktntajd. com (Ape Kate Ente Aje Deh!) ----- Original Message ----- From: toviconline To: Programmer-VB@ yahoogroups. com Sent: Friday, July 27, 2007 11:16 AM Subject: [Programmer- VB] Undo drop tabel di SQL server Dear All, Bisa gak tabel yang sudah terhapus/drop di SQL server kita Undo drop jadi ada lagi...kalau bisa caranya bagaimana? thx b4 :D ------------------------------------------------------------------------------ Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.
