下载SQL数据库

最新推荐文章于 2024-07-30 11:20:44 发布

最新推荐文章于 2024-07-30 11:20:44 发布 · 133 阅读

文章标签：

该博客介绍了SQL Server数据库的备份与恢复操作。通过HTML表单让用户选择备份或恢复操作，输入数据库名和文件路径。使用ASP代码实现与SQL Server的连接，根据用户选择执行备份或恢复操作，并给出相应提示信息。

<HTML>
<HEAD>
<TITLE>SQLServer数据库的备份与恢复</TITLE>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
</HEAD>
<BODY>
<formmethod="post"name=myform>
选择操作：<INPUTTYPE="radio"NAME="act"id="act_backup"value="backup"><labelfor=act_backup>备份</label>　
<INPUTTYPE="radio"NAME="act"id="act_restore"value="restore"><labelfor=act_restore>恢复</label>
 数据库名：<INPUTTYPE="text"NAME="databasename"value="<%=request("databasename")%>">
 文件路径：<INPUTTYPE="text"NAME="bak_file"value="c:\1.exe">(备份或恢复的文件路径,备份成EXE主要为了方便下载,活活..) 
<inputtype="submit"value="确定">
</form>
<%
dimsqlserver,sqlname,sqlpassword,sqlLoginTimeout,databasename,bak_file,act
sqlserver="localhost"'sql服务器
sqlname="sa"'用户名
sqlpassword="数据库密码"'密码
sqlLoginTimeout=15'登陆超时
databasename=trim(request("databasename"))
bak_file=trim(request("bak_file"))
bak_file=replace(bak_file,"$1",databasename)
act=lcase(request("act"))
ifdatabasename=""then
response.write"inputdatabasename"
else
ifact="backup"then
Setsrv=Server.CreateObject("SQLDMO.SQLServer")
srv.LoginTimeout=sqlLoginTimeout
srv.Connectsqlserver,sqlname,sqlpassword
Setbak=Server.CreateObject("SQLDMO.Backup")
bak.Database=databasename
bak.Devices=Files
bak.Files=bak_file
bak.SQLBackupsrv
iferr.number>0then
response.writeerr.number&"<fontcolor=red> "
response.writeerr.description&""
endif
Response.write"<fontcolor=green>备份成功!"
elseifact="restore"then
'恢复时要在没有使用数据库时进行！
Setsrv=Server.CreateObject("SQLDMO.SQLServer")
srv.LoginTimeout=sqlLoginTimeout
srv.Connectsqlserver,sqlname,sqlpassword
Setrest=Server.CreateObject("SQLDMO.Restore")
rest.Action=0'fulldbrestore
rest.Database=databasename
rest.Devices=Files
rest.Files=bak_file
rest.ReplaceDatabase=True'Forcerestoreoverexistingdatabase
iferr.number>0then
response.writeerr.number&"<fontcolor=red> "
response.writeerr.description&""
endif
rest.SQLRestoresrv

Response.write"<fontcolor=green>恢复成功!"
else
Response.write"<fontcolor=red>没有选择操作"
endif
endif
%>
</BODY>
</HTML>