<style type="text/css">
<!--
body {
	background-color: #DEE7FF;
}
-->
</style>
<% 
Server.ScriptTimeOut=90000

d=day(now())
if d<10 then
d="0" & d
end if
m=month(now())
if m<10 then
m="0" & m
end if
BQ=session("sqlName")
dayth=year(now()) & m & d
dayth=dayth&".bak"
dayth=BQ&"_"&dayth
PathName="Bak"

Set hdobj = Server.CreateObject("HD.ComOpen")
BP=hdobj.BackPath("P")

dim sql,cnn
SQL="backup database "& BQ &" to disk='"&Server.MapPath(PathName)&"\"&dayth&"'" 
set cnn=Server.createobject("adodb.connection") 
cnn.open "driver={SQL Server};"& BP
cnn.execute SQL 

on error resume next 
if err<>0 then 
response.write "錯誤："&err.Descripting 
else 
response.write "<br><br><br><br><br><br><p align='center'>數據備份成功</p>"

end if 



%>