1. Backup
<%
SQL="backupdatabase database name todisk='"&Server.MapPath("backup")&"//"&"backuptext.dat"&"'"
setcnn=Server.createobject("adodb.connection")
cnn.open"driver={SQLServer};Server=server name;uid=sa;pwd="
cnn.executeSQL
onerrorresumenext
iferr<>0then
response.write"Error:"&err.Descripting
else
response.write "Data backup was successful!"
endif
%>Green chinaipower.comAYrCJ6B
2. Recovery
<%
SQL="Restoredatabase database name fromdisk='"&Server.MapPath("backup")&"//"&"backuptext.dat"&"'"
setcnn=Server.createobject("adodb.connection")
cnn.open"driver={SQLServer};Server=server name;uid=sa;pwd="
cnn.executeSQL
onerrorresumenext
iferr<>0then
response.write"Error:"&err.Descripting
else
response.write "Data recovery succeeded!"
endif
%>