我的差异备份代码如下(完全备份已经做好).但是执行时,在对应的目录下找不到所备份文件.
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&Reg_dbname & ".bak with DIFFERENTIAL"
MsgBox strSql
dbconn.execute strSql
Set dbconn=nothing
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&Reg_dbname & ".bak with DIFFERENTIAL"
MsgBox strSql
dbconn.execute strSql
Set dbconn=nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货