======================BACKUP=================================== BACKUP DATABASE databasenya TO DISK ='C:\tes restore.bak' WITH NOFORMAT, INIT, NAME = N'YourDatabase-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 =====================RESTORE================================== USE MASTER RESTORE DATABASE databasenya FROM DISK ='C:\tes restore.bak' USE databasenya ======================CATATAN================================= catatan usernya harus di kasih akses yg sama dengan system administrator atau disk administrator atau database creators
kalo masalah waktu dan tanggal aku gak ngerti pertanyaannya :) semoga bisa membantu Kunkun Kurniadi <[EMAIL PROTECTED]> wrote: Hallo semua, Saya Ingin menanyakan coding untuk BackUp & Restore di Vb 6 dengan databasenya SQLserver. Kalau Bisa Backup & Restore nya bisa dipilih berdasarkan waktu atau tanggal. Ditunggu jawabannya. Terima kasih Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] --------------------------------- Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed]
