备份与恢复SQL Server|备份与恢复SQL Server

投稿

繁体

RSS

首页

网站运营

欢迎在本站发布信息，在线投递稿件请点这里。编辑QQ:4908220，欢迎联系交流。
业界动态	创业故事	推广研究	策划盈利	电子商务	企业平台
站长工具
SEO查询	Whois查询	Pr查询	域名查询	IP查询	网页编辑器

建站服务

如有建站意向，请尽快联系我们，以便安排时间... QQ:4908220
作品展示	服务范围	服务流程	服务报价	联系方式	付款方式

站长论坛

交流区
站长酒吧	SEO&推广	网赚交流	建站系统

服务&信息
招聘求职	项目外包	广告发布	网络资源

技术区
网页设计师	界面设计师	WEB程序员	计算机应用

文章正文	» 您的当前位置：首页 >> 学院 >> 程序开发 >> ASP

备份与恢复SQL Server

来源：互联网 | 时间：2005-10-04 | 浏览：相关评论 | 报告错误 | 发布文章

【字号：大 | 中 | 小】【背景色

】

一个用asp备份与恢复SQL Server数据库的例子代码

<HTML>
<HEAD>
<TITLE>数据库操作</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>

<BODY>
<form method="post" name=myform>
<%if action="restore" then%><INPUT TYPE="hidden" name="action" value="restore">准备恢复数据库。。。
<%elseif action="backup" then%><INPUT TYPE="hidden" name="action" value="backup">准备备份数据库。。。<%else%>
选择操作：
<INPUT TYPE="radio" name="action" id="act_backup"  value="backup"><label for=act_backup>备份</label>　
<INPUT TYPE="radio" name="action" id="act_restore" value="restore"><label for=act_restore>恢复</label><%end if%>
<br>数据库名：<INPUT TYPE="text" name="databasename" value="50forum">
<br>文件路径：<INPUT TYPE="text" name="bak_file" value="50forum.bak">(备份或恢复的文件路径)<br>
<input type="submit" value="确定">
</form>
<%
"SQL Server 数据库的备份与恢复!
dim sqlserver,sqlname,sqlpassword,sqlLoginTimeout,databasename,bak_file,act
sqlserver = "localhost"	"sql服务器
sqlname = "sa"			"用户名
sqlpassword = "sa"		"密码
sqlLoginTimeout = 15	"登陆超时
databasename = trim(request("databasename"))
bak_file = trim(request("bak_file"))
bak_file = Server.MapPath("backup/"&bak_file)
act = lcase(request("action"))

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.Files				= bak_file
		bak.Action				= 0
		bak.Initialize			= 1
		"bak.ReplaceDatabase		= True
		bak.SQLBackup srv
		if err.number>0 then
			response.write err.number&"<font color=red><br>"
			response.write err.description&"<div id="gg_ad_img"></div>
</td>
</tr>
<tr>
<td id="article_ad"></td>
</tr>
<tr>
<td align="right"><img height="20" 
alt="master8" src="/images/m.gif" width="20" 
/></a></td>
</tr>
<tr>
<td style="line-height:180%;background-color:#f3f3f3;padding:5px;" id="article_copyright"> </td>
</tr>
</table>

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>

</td>
</tr>
<tr>
<td>
<li><span class="f_red f_b">上一篇：</span><a href="/data/2005/1004/article_608.htm" title="调用winrar压缩文件夹" class="f_b">调用winrar压缩文件夹</a></li>
<li><span class="f_red f_b">下一篇：</span><a href="/data/2005/1223/article_1295.htm" title="万维网创始人博客处女秀" class="f_b">万维网创始人博客处女秀</a></li>
</td>
</tr>
</table>

<br />
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="23" align="center" bgcolor="#f3f3f3"><a href="/contribute.php" target="_blank"><img src="/images/pencil.gif" width="18" height="18" align="absmiddle" border="0"> 我要投稿</a>　<a href="javascript:window.print();"><img src="/images/print.gif" width="19" height="16" align="absmiddle" border="0"> 打印本文</a>　<a href="javascript:copy();"><img src="/images/commend.gif" width="19" height="14" align="absmiddle" border="0"> 推荐本文</a>　<a href="javascript:window.external.addFavorite(window.location,'备份与恢复SQL Server')"><img src="/images/favorite.gif" width="22" height="14" align="absmiddle" border="0"> 加入收藏</a>　<a href="#top"><img src="/images/top.gif" width="12" height="11" align="absmiddle" border="0"> 返回顶部</a>　<a href="javascript:window.close()"><img src="/images/close.gif" width="23" height="18" align="absmiddle" border="0"> 关闭窗口</a></td>
</tr>

<li class="line"><span class="f_r f_d">12-03</span><a href="/data/2007/1203/article_10987.htm" target="_blank">软件发布：风越ASP代码生成器 [FireAsp Creator] V1.8</a></li>

<li class="line"><span class="f_r f_d">07-10</span><a href="/data/2007/0710/article_10335.htm" target="_blank">ASP种种错误提示解决方案</a></li>

<li class="line"><span class="f_r f_d">07-10</span><a href="/data/2007/0710/article_10332.htm" target="_blank">Asp+Sql 对数据库的各种操作</a></li>

<li class="line"><span class="f_r f_d">07-06</span><a href="/data/2007/0706/article_10279.htm" target="_blank">ASP Session</a></li>

<li class="line"><span class="f_r f_d">06-30</span><a href="/data/2007/0630/article_10182.htm" target="_blank">ASP 编程中20个非常有用的例子</a></li>

</ul>
</td>
</tr>

</table>

</td>
</table>

</td>
</tr>
</table>

</td>
<td class="td_right" valign="top">

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2007/0710/article_10335.htm"  target="_blank" class="l" title="ASP种种错误提示解决方案">ASP种种错误提示解决方案</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2006/0414/article_2716.htm"  target="_blank" class="l" title="从ASP过渡到ASP.net遗留的二十大积习">从ASP过渡到ASP.net遗留的二十大...</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2006/0407/article_2636.htm"  target="_blank" class="l" title="如何把ASP编写成DLL">如何把ASP编写成DLL</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2006/0405/article_2625.htm"  target="_blank" class="l" title="ASP开发中存储过程应用全接触">ASP开发中存储过程应用全接触</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2006/0405/article_2624.htm"  target="_blank" class="l" title="利用ASP发送和接收XML数据的处理方法">利用ASP发送和接收XML数据的处理...</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2005/1122/article_1148.htm"  target="_blank" class="l" title="ASP自动解压RAR文件">ASP自动解压RAR文件</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2005/1001/article_428.htm"  target="_blank" class="l" title="用php如何操作LDAP">用php如何操作LDAP</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2005/1001/article_416.htm"  target="_blank" class="l" title="ASP开发web站点">ASP开发web站点</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2005/0926/article_369.htm"  target="_blank" class="l" title="用ASP实现远程抓取网页到本地数据库">用ASP实现远程抓取网页到本地数...</a></li>

<li class="li1"><img src="/images/icon_1.gif" width="10" height="11" align="absmiddle"/> <a href="/data/2005/0926/article_367.htm"  target="_blank" class="l" title="ASP无组件上传进度条解决方案">ASP无组件上传进度条解决方案</a></li>

</ul>
</td>
</tr>
</table>

</ul>
</td>
</tr>
<form name="myform" method="post" action="/comment.php?articleid=609" onsubmit="return doCheck();">
<tr>
<td>
<ul>
<li class="line"><input name="username" type="text" id="username" size="25" maxlength="30" value="姓名" onclick="if(this.value=='姓名')this.value='';"></li>
<li style="padding-left:3px;"><textarea name="content" cols="80" rows="5" id="content">

验证码: