sql server 7种的备份方法
If cn.State = adStateOpen Then cn.Close
cn.ConnectionTimeout = 10
connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb
cn.Open connstr
Nowtime = Format(Now, "hh-mm-ss")
dd = Str(Date)
riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"
cn.Execute (SQL)http://www.dapha.net/有原代码执行SQL命令"BACKUP DATABASE [数据库名] TO DISK='带路径文件名'" 即可备份"RESTORE DATABASE [数据库名] FROM DISK ='带路径文件名'" 可恢复数据dim objsvr as new sqldmo.sqlserver
dim objbak as new sqldmo.backupobjsvr.connect %server%,%login%,%pwd"
with objbak
.database=%databasename%
.files=%filesname%
.sqlbackup
end withset objdatabase=nothing
set objsvr=nothing
If cn.State = adStateOpen Then cn.Close
cn.ConnectionTimeout = 10
connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb
cn.Open connstr
Nowtime = Format(Now, "hh-mm-ss")
dd = Str(Date)
riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"
cn.Execute (SQL)http://www.dapha.net/有原代码执行SQL命令"BACKUP DATABASE [数据库名] TO DISK='带路径文件名'" 即可备份"RESTORE DATABASE [数据库名] FROM DISK ='带路径文件名'" 可恢复数据dim objsvr as new sqldmo.sqlserver
dim objbak as new sqldmo.backupobjsvr.connect %server%,%login%,%pwd"
with objbak
.database=%databasename%
.files=%filesname%
.sqlbackup
end withset objdatabase=nothing
set objsvr=nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货