ASP實現SQL備份、恢複

1、備份
<%
SQL="backup database 資料庫名 to disk='"&Server.MapPath("backup")&"\\"&"backuptext.dat"&"'"
set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=伺服器名;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "錯誤："&err.Descripting
else
response.write "資料備份成功！"
end if
%>綠色c hinaip ower. comAYrCJ6B

2、恢複
<%
SQL="Restore database 資料庫名 from disk='"&Server.MapPath("backup")&"\\"&"backuptext.dat"&"'"
set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=伺服器名;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "錯誤："&err.Descripting
else
response.write "資料恢複成功！"
end if
%>