非常好用的asp备份,还原SQL数据库的代码
2023-06-13 09:14:01 时间
<form method="post" name="myform" action="?action=backupdatabase">
选择操作:
<input type="radio" name="act" id="act_backup"value="backup">
<label for=act_backup>备份</label>
<input type="radio" name="act" id="act_restore" value="restore">
<label for=act_restore>恢复</label>
<br>
数据库名:
<input type="text" name="databasename" value="<%=request("databasename")%>">
<br>
文件路径:
<input type="text" name="bak_file" value="c:\$1.bak">
(备份或恢复的文件路径)<br>
<input type="submit" value="确定" id=submit1 name=submit1>
</form>
<%
"sql server 数据库的备份与恢复!
if request("action")="backupdatabase" then
dim sqlserver,sqlname,sqlpassword,sqllogintimeout,databasename,bak_file,act
"**************************************************************************
sqlserver = "127.0.0.1"
sqlname = "sa "
sqlpassword ="111"
sqllogintimeout = 15
databasename = trim(request("databasename"))
bak_file = trim(request("bak_file"))
bak_file = replace(bak_file,"$1",databasename)
act = lcase(request("act"))
"**************************************************************************
if databasename = "" then
response.write "input database name"
else
if act = "backup" then
set srv=server.createobject("sqldmo.sqlserver")
srv.logintimeout = sqllogintimeout
srv.connect sqlserver,sqlname, sqlpassword
set bak = server.createobject("sqldmo.backup")
bak.database=databasename
bak.devices=files
bak.action = 0
bak.initialize = 1
"bak.replace = true
bak.files=bak_file
bak.sqlbackup srv
if err.number>0 then
response.write err.number&"<font color=red><br>"
response.write err.description&"</font>"
end if
response.write "<font color=green>备份成功!</font>"
end if
if act="restore" then
"恢复时要在没有使用数据库时进行!
set srv=server.createobject("sqldmo.sqlserver")
srv.logintimeout = sqllogintimeout
srv.connect sqlserver,sqlname, sqlpassword
set rest=server.createobject("sqldmo.restore")
rest.action=0 " full db restore
rest.database=databasename
rest.devices=files
rest.files=bak_file
rest.replacedatabase=true "force restore over existing database
if err.number>0 then
response.write err.number&"<font color=red><br>"
response.write err.description&"</font>"
end if
rest.sqlrestore srv
response.write "<font color=green>恢复成功!</font>"
else
response.write "<font color=red>没有选择操作</font>"
end if
end if
end if
%>
选择操作:
<input type="radio" name="act" id="act_backup"value="backup">
<label for=act_backup>备份</label>
<input type="radio" name="act" id="act_restore" value="restore">
<label for=act_restore>恢复</label>
<br>
数据库名:
<input type="text" name="databasename" value="<%=request("databasename")%>">
<br>
文件路径:
<input type="text" name="bak_file" value="c:\$1.bak">
(备份或恢复的文件路径)<br>
<input type="submit" value="确定" id=submit1 name=submit1>
</form>
<%
"sql server 数据库的备份与恢复!
if request("action")="backupdatabase" then
dim sqlserver,sqlname,sqlpassword,sqllogintimeout,databasename,bak_file,act
"**************************************************************************
sqlserver = "127.0.0.1"
sqlname = "sa "
sqlpassword ="111"
sqllogintimeout = 15
databasename = trim(request("databasename"))
bak_file = trim(request("bak_file"))
bak_file = replace(bak_file,"$1",databasename)
act = lcase(request("act"))
"**************************************************************************
if databasename = "" then
response.write "input database name"
else
if act = "backup" then
set srv=server.createobject("sqldmo.sqlserver")
srv.logintimeout = sqllogintimeout
srv.connect sqlserver,sqlname, sqlpassword
set bak = server.createobject("sqldmo.backup")
bak.database=databasename
bak.devices=files
bak.action = 0
bak.initialize = 1
"bak.replace = true
bak.files=bak_file
bak.sqlbackup srv
if err.number>0 then
response.write err.number&"<font color=red><br>"
response.write err.description&"</font>"
end if
response.write "<font color=green>备份成功!</font>"
end if
if act="restore" then
"恢复时要在没有使用数据库时进行!
set srv=server.createobject("sqldmo.sqlserver")
srv.logintimeout = sqllogintimeout
srv.connect sqlserver,sqlname, sqlpassword
set rest=server.createobject("sqldmo.restore")
rest.action=0 " full db restore
rest.database=databasename
rest.devices=files
rest.files=bak_file
rest.replacedatabase=true "force restore over existing database
if err.number>0 then
response.write err.number&"<font color=red><br>"
response.write err.description&"</font>"
end if
rest.sqlrestore srv
response.write "<font color=green>恢复成功!</font>"
else
response.write "<font color=red>没有选择操作</font>"
end if
end if
end if
%>
相关文章
- asp.net员工管理系统VS开发sqlserver数据库web结构c#编程计算机网页项目
- mysql锁表查询和解锁操作详解数据库
- ASP如何连接MySQL数据库(asp怎么连接mysql)
- 如何使用C ASP实现MySQL数据库连接(c asp连接mysql)
- 使用 ASP 实现 MySql 数据库的分页功能(asp连接mysql分页)
- 在MySQL5中使用ASP搭建数据库连接(asp连接mysql5)
- ASP转换MySQL掌握数据库迁移技术(asp转换为mysql)
- ASP编程存取MySQL数据库出现乱码问题(asp读mysql乱码)
- ASP如何使用代码登录MySQL数据库(asp登陆mysql代码)
- ASP构建MySQL数据库从零出发(asp数据库mysql)
- 基于ASP技术连接MySQL数据库(asp支持mysql)
- 数据库探索ASP环境搭建MySQL数据库方法(asp搭建mysql)
- ASP开发搭配MySQL更加优雅的数据库处理(asp加mysql)
- ASP控制下的Oracle数据库管理初体验(asp控制oracle)
- asp.net数据库备份还原(sqlserver+access)
- Asp操作Access数据库时出现死锁.ldb的解决方法
- asp.net下Oracle,SQLServer,Access万能数据库通用类
- Asp实现的数据库连接池功能函数分享