asp备份,还原SQL数据库--非常好用.--2006-6-8-5
来源:互联网 发布:java中蓝色注解 编辑:程序博客网 时间:2024/06/05 10:44
<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备份,还原SQL数据库--非常好用.--2006-6-8-5
- asp.net备份还原sql数据库
- asp 备份还原数据库
- sql 数据库备份还原
- sql 备份还原数据库
- sql 备份还原数据库
- SQL数据库备份还原
- 在asp.net中备份还原SQL Server数据库
- 在asp.net中备份还原SQL Server数据库
- 在asp.net中备份还原SQL Server数据库
- 在asp.net中备份还原SQL Server数据库
- Asp.Net 备份和还原SQL SERVER 数据库
- sql sever2005数据库备份和还原(Asp.net C#)
- 在asp.net中备份还原SQL Server数据库
- asp.net 还原、备份数据库
- ASP.NET备份还原数据库
- ASP.NET备份还原数据库
- ASP.NET备份还原数据库
- 一个小问题的解决
- 一个LINUX高手写给初学者的话
- 软件质量有何需求?
- DOSBox0.65前端D-Fend v2 beta 2简体中文版
- 业内巨头竞相争夺硅谷初创企业
- asp备份,还原SQL数据库--非常好用.--2006-6-8-5
- 利用XSLT将线性XML转换为树型XML
- JAVA相关基础知识(一)
- 病例:不理解C/C++的函数指针
- 世界杯赛程
- 破解庞加莱猜想--中国人干的!
- 完全评价
- WebLogic运用DB的Java控件访问数据库
- 关于给精英松绑的讨论...