<%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	
%>