使用adoconn.execute "backup database {databasename} to backup_file" 详查sql帮助使用SQLDMO 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"
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"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货