Coba km liat di F1 
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1
atau bisa juga langsung
BACKUP DATABASE MyNwind TO DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
Kalo Restore
RESTORE DATABASE MyNwind FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
Mas,,Sintak Backupnya dah bisa. Saya seperti ini :
cek="BACKUP DATABASE dbkoperasi TO DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\dbkoperasi_1.dat'"
If SQLExec(ckonek,cek,'backup')>0
Messagebox("BACKUP DATABASE BERHASIL",64,"SUKSES")
Else
Messagebox("BACKUP DATABASE GAGAL",64,"GAGAL")
Endif
Sudah berhasil...
Cuma Restorenya kok g bisa yach..
Seperti ini :
cek="RESTORE DATABASE dbkoperasi FROM DISK = 'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\dbkoperasi_1.dat'"
If SQLExec(ckonek,cek,'backup1')>0
Messagebox("RESTORE DATABASE BERHASIL",64,"SUKSES")
Else
Messagebox("RESTORE DATABASE GAGAL",64,"GAGAL")
Endif
Gagal terus..
Kondisinya mesti gimana ya Mas??? Mohon bimbingannya
