?? bf.asp
字號:
<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
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -