在VB中使用sql命令備份，我沒試過。但SQL中有一個自動功能，可以試一試。 
    在數(shù)據(jù)庫上右擊，選擇All Tasks>>Backup Database>>Schedule.... 
<END>     
execute "sp_aqddumpdevice ..." 
    還可以用execute "backup database {databasename} to <backup_file" 
    創(chuàng)建一個臨時備份文件。 
<END>     
最好使用SQLDMO的backup 對象，如何使用請查看Sql server的 book online。不過要懂點 COM。 
<END>     
Dim Svr As New SQLDMO.SQLServer 
    Dim DB As SQLDMO.Database 
    Dim BK As New SQLDMO.Backup 
    Dim DV As New SQLDMO.BackupDevice 
    Svr.Connect "(local)", "sa" 
    DV.Type = SQLDMODevice_DiskDump 
    DV.Name = "pubsbak" 
    DV.PhysicalLocation = "c:\mssql7\bakup\pubs.bak" 
    On Error Resume Next 
    Svr.BackupDevices.Add DV 
    On Error GoTo 0 
    BK.Database = "pubs" 
    BK.Devices = "pubsbak" 
    BK.Initialize = True 
    BK.SQLBackup Svr 
    Svr.BackupDevices.Remove "pubsbak" 
<END>