1。バックアップ
<%
sql = "backupdatabaseデータベース名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 <> 0 -then
Response.write "エラー:"&err.descripting
それ以外
response.write「データのバックアップが成功しました!」
endif
%> Green Chinaipower.comayrcj6b
2。回復
<%
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 <> 0 -then
Response.write "エラー:"&err.descripting
それ以外
response.write「データの回復が成功しました!」
endif
%>