alhamdulillah sudah ketemu solusinya dan sudah berhasil di attach lagi referensi ada di link ini: http://www.spaceprogram.com/knowledge/2002/06/recovering-from-deleted-log-file-on_12.html
----- Original Message ----- From: Lai Min Feng To: [email protected] Sent: Friday, May 11, 2007 10:13 AM Subject: RE: [Programmer-VB] database error hmm.. sepertinya lognya rusak. coba lognya dihapus.. (jangan lupa backup dulu, kali2 gak efek) lalu coba di attach ulang.. biar dia bikin dari kosong lagi lognya.. ======================= http://www.fire888.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of dodo Sent: Friday, May 11, 2007 8:53 AM To: [email protected] Subject: [Programmer-VB] database error assalam... mohon bantuan temen2 semua: database sql server2000 saya rusak: saat mau di-attach muncul error: Error 9003: The LSN (6056:128:1) passed to log scan in database 'Aios' is invalid solusinya gimana ya? gara2nya: komputer yg ada sql-servernya sudah dishutdown tapi masih ada komputer client yang mengakses database, setelah besoknya: database nya sudah "SUSPECT", saya detach dulu... lalu mau saya attach lagi: muncullah error itu... saya sudah pake cara sp_add_data_file_recovery: tetep ngga bisa... ada solusi? terima kasih dodo wassalam... ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.6.8/797 - Release Date: 5/10/2007 5:10 PM
