?? db_hfcz.asp
字號:
<%response.expires=0 '設置瀏覽器緩存頁面的時間
hf=request("hf")
if hf="" then '用條件語句判斷選擇的恢復信息不能為空
response.write "<title>提示頁面</title><br><br><br><br><br><br><p align='center'><font face='楷體_GB2312' size='5' color=#ff0000><b>"& "<br>必須選定一項要恢復的數據,請查清后重試!</b></font></p>"
response.write "<p align='center'><a href='javascript:history.back(1)'>返回</a></p>"
response.end
end if
'連接數據庫
str=server.mappath("../backup") & "\" & hf
set conn=server.createobject("adodb.connection")
conn.connectionstring="Driver={Sql Server};Server=(local);UID=sa"
conn.open
on error resume next '設置錯誤陷阱
conn.execute " alter database db_lsmanage set single_user with rollback immediate restore database DB_Lsmanage from disk = '" & str & "'"
response.write "<title>提示頁面</title><br><br><br><br><br><br><p align='center'><font face='楷體_GB2312' size='5' color=#ff0000><b>"
if err.number=0 then
response.Redirect("restoreOK.asp") '無錯誤信息跳轉到數據恢復成功頁面
else
response.write "<br>數據庫恢復失敗,請檢查后重試!</b></font></p><br><center><a href='javascript:history.back(1)'>返回</a></center>"
response.write err.Description '輸出系統的錯誤提示信息
end if
conn.execute " alter database db_lsmanage set MULTI_USER" '將數據庫設置為多用戶
set conn=nothing
conn.close
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -