用vbs脚本,如何对sqlserver进行差异(增量)备份?

[chen99yjeyotech]

用vbs脚本,如何对sqlserver进行差异(增量)备份?

[chen99yjeyotech]

我的差异备份代码如下(完全备份已经做好).但是执行时,在对应的目录下找不到所备份文件.
strConn="Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=" & Reg_dbname & ";Data Source=" & Reg_oraserver
Set dbconn=WScript.CreateObject("ADODB.CONNECTION")
dbconn.Open strConn,Reg_user_name,Reg_user_password
strSql="BACKUP DATABASE "& Reg_dbname &" TO disk=" & Reg_BackPath &"\"&Date®_dbname & ".bak with DIFFERENTIAL"
MsgBox strSql
dbconn.execute strSql
Set dbconn=nothing