1、備份
<%
SQL="backupdatabase數據庫名todisk='"&Server.MapPath("backup")&"//"&"backuptext.dat"&"'"
setcnn=Server.createobject("adodb.connection")
cnn.open"driver={SQLServer};Server=服務器名;uid=sa;pwd="
cnn.executeSQL
onerrorresumenext
iferr<>0then
response.write"錯誤："&err.Descripting
else
response.write"數據備份成功！"
endif
%>綠色chinaipower.comAYrCJ6B
2、恢復
<%
SQL="Restoredatabase數據庫名fromdisk='"&Server.MapPath("backup")&"//"&"backuptext.dat"&"'"
setcnn=Server.createobject("adodb.connection")
cnn.open"driver={SQLServer};Server=服務器名;uid=sa;pwd="
cnn.executeSQL
onerrorresumenext
iferr<>0then
response.write"錯誤："&err.Descripting
else
response.write"數據恢復成功！"
endif
%>