Kalo udah di backup, cara restorenya : Create new database dengan nama yg sama, terus klik kanan di nama databasenya, pilih all task, restore db. Terus pilih from device, terus browse file backupnya. Terus pindah tab, centang di bagian force over existing database, yg perlu diperhatiin, path mdf ama ldfnya harus sama. Terus klik restore. Oh iya, kalo mau restore sukses, gak boleh ada user yg lagi akses dbnya, selain user yg restore.
Cara laennya kalo udah ada file mdf, ldf nya, tinggal klik kanan di server, pilih attach db, terus next, next aja. Cmiiw -----Original Message----- From: Andi Kristyawan <[EMAIL PROTECTED]> Date: Thu, 14 Feb 2008 06:41:37 To:VB <[email protected]> Subject: [Programmer-VB] Cara restore data Haii Ada yang mau saya tanyakan di forum ini? Saya menggunakan database SqlServer2000, datanya sdh saya backup. Masalahnya data yang sdh saya backup mau saya taruh dikomputer yang lain, tapi tetap tidak bisa saya restore datanya <Note komputernya sdh saya install SQLSERVER 2000>. Bagaimana caranya merestore data tersebut Terima Kasih andi ---------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > 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/
