备份与恢复SQL Server - 站长吧 - 中国站长学习与交流

一个用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 class="t_c"> </div>
</div>
<div id="gg468" class="t_c"></div>
<br/><br/>
<div class="t_r info">
<a href="javascript:T('备份与恢复SQL Server', 2);"><img src="/ui/2008/tips.gif" width="12" height="13"  alt=""/> Tags: 备份与恢复SQL Server,</a>
<a href="/school/asp/"><img src="/ui/2008/i_6.gif" width="15" height="10"  alt=""/> 分类:ASP</a>

<div class="mn"> </div>
<div class="mr">
		<div class="mb" style="width:298px;overflow:hidden;">
		
<center>
<form method="get" action="http://www.google.cn/search" target="google_window">
<table bgcolor="#ffffff">
<tr><td nowrap="nowrap" valign="top" align="left">
<table bgcolor="#ffffff">
<tr><td nowrap="nowrap" valign="top" align="left" height="32">
<a href="http://www.google.com/">
<img src="http://www.google.com/logos/Logo_25wht.gif" border="0" alt="Google" align="middle"></img></a>
<label for="sbi" style="display: none">输入您的搜索字词</label>
<input type="text" name="q" size="18" maxlength="255" value="" id="sbi"></input>
<label for="sbb" style="display: none">提交搜索表单</label>
<input type="submit" name="sa" value="搜 索" id="sbb" class="btn"></input>
<input type="hidden" name="client" value="pub-4033383233178129"></input>
<input type="hidden" name="forid" value="1"></input>
<input type="hidden" name="prog" value="aff"></input>
<input type="hidden" name="channel" value="0403244999"></input>
<input type="hidden" name="ie" value="GB2312"></input>
<input type="hidden" name="oe" value="GB2312"></input>
<input type="hidden" name="hl" value="zh-CN"></input>
</td></tr></table>
</td></tr><tr><td nowrap="nowrap" valign="top" align="left">
<script type="text/javascript">
</script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
</form>
</center>
</div>
<div class="b_8"></div>
<div class="mb">
<div class="mu">
<ul>

<li><a href="http://www.cnkuai.cn/host.htm" target="_blank" title="虚拟主机,网站空间,ASP空间,空间"><font color="red"><b>虚拟主机</b></font></a>
<a href="http://www.cnkuai.cn/domain.htm" target="_blank" title="中文域名,中文域名注册,中文域名申请"><font color="red"><b>中文域名</b></font></a></li>
<li><span class="px10">AD:</span> <a href="/service/adv.html"><span class="f_red">全站广告位预定QQ4908220</span></a></li>
</ul>
</div>
</div>
<div class="b_8"></div>

<table width="100%" cellpadding="0" cellspacing="0">
<tr align="center">
<td height="22" width="70" class="tab_on" id="tab_1"><a href="http://bbs.master8.net/" target="_blank"><strong>论坛精华</strong></a></td>
<td class="tab_out"> </td>
</tr>
</table>
<div style="border:#CAD9EA 1px solid;border-top:none;">
<div id="cont_1" class="mu">
<ul>
<li><a href="http://bbs.master8.net/?show-8596.html" title="日期:2008-09-03 22:56
浏览:279" target="_blank">国外译文：域名停放全攻略</a></li>

<li><a href="http://bbs.master8.net/?show-8581.html" title="日期:2008-09-03 11:40
浏览:274" target="_blank">谷歌推出开源网络浏览器Chrome</a></li>

<li><a href="http://bbs.master8.net/?show-8566.html" title="日期:2008-09-02 21:57
浏览:264" target="_blank">网管员安全训练营--让FTP服务器更安全</a></li>

<li><a href="http://bbs.master8.net/?show-8440.html" title="日期:2008-08-28 23:08
浏览:387" target="_blank">我的网站用户，你在哪里？</a></li>

<li><a href="http://bbs.master8.net/?show-8407.html" title="日期:2008-08-28 11:49
浏览:500" target="_blank">【*经验之谈*】：服务器托管必用的10大工具</a></li>

</ul>
</div>
</div>
<div class="b_8"></div>
<div class="mb">
<div class="mt">
<span class="f_r"><script type="text/javascript">cMore(1);</script></span>
<a href="/manage/" target="_blank"><strong>网站运营</strong></a></div>
<div class="mu" id="c_1"><ul><li>[<a href="/manage/it/">IT看台</a>] <a href="/manage/it/show-10791.html" title="By:年华 At:2008-10-09" target="_blank">人民日报：领导如何面对网络时代</a></li>
<li>[<a href="/manage/webmaster/">HI! 站长</a>] <a href="/manage/webmaster/show-10790.html" title="By:小资 At:2008-10-08" target="_blank">中国广东核电集团 2009校园招聘启动仪式10月12日将隆重举行</a></li>
<li>[<a href="/manage/it/">IT看台</a>] <a href="/manage/it/show-10789.html" title="By:小资 At:2008-09-26" target="_blank">4200万中小企业 10%企业邮局使用率</a></li>
<li>[<a href="/manage/it/">IT看台</a>] <a href="/manage/it/show-10788.html" title="By:小资 At:2008-09-19" target="_blank">高端技术行业领跑 代理市场前景广阔</a></li>
<li>[<a href="/manage/it/">IT看台</a>] <a href="/manage/it/show-10787.html" title="By:年华 At:2008-09-18" target="_blank">BitTorrent第三轮融资获投1700万美元</a></li>
<li>[<a href="/manage/it/">IT看台</a>] <a href="/manage/it/show-10786.html" title="By:年华 At:2008-09-18" target="_blank">谷歌CEO：与雅虎合作无需征得政府额外同意</a></li>

</ul></div>
</div>
<div class="b_8"></div>
<div class="mb">
<div class="mt">
<span class="f_r"><script type="text/javascript">cMore(2);</script></span>
<a href="/school/" target="_blank"><strong>站长学院</strong></a></div>
<div class="mu" id="c_2"><ul><li>[<a href="/school/iis/">IIS</a>] <a href="/school/iis/show-10582.html" title="By:年华 At:2008-10-09" target="_blank">服务器轻松架 IIS7.0安装/调试全攻略</a></li>
<li>[<a href="/school/photoshop/">PhotoShop</a>] <a href="/school/photoshop/show-10581.html" title="By:年华 At:2008-10-09" target="_blank">Photoshop鲜为人知的75个技巧</a></li>
<li>[<a href="/school/software/">软件应用</a>] <a href="/school/software/show-10580.html" title="By:年华 At:2008-10-09" target="_blank">Windows2000/XP系统文件受损的修复方法</a></li>
<li>[<a href="/school/mssql/">MSSQL</a>] <a href="/school/mssql/show-10579.html" title="By:年华 At:2008-10-09" target="_blank">浅析SQL Server 2008企业级新特性</a></li>
<li>[<a href="/school/software/">软件应用</a>] <a href="/school/software/show-10578.html" title="By:年华 At:2008-10-09" target="_blank">GHOST使用详解</a></li>
<li>[<a href="/school/linux/">Linux/BSD</a>] <a href="/school/linux/show-10577.html" title="By:年华 At:2008-10-09" target="_blank">linux系统下设置IP地址并激活方法</a></li>

</ul></div>
</div>
<div class="b_8"></div>

<div class="mb">
<div class="mt1"><a href="/mail/" target="_blank"><strong>文章订阅</strong></a></div>
<div style="height:85px;">
<form action="/mail/index.php" method="post">
<ul style="margin:0 0 0 13px;">
<li class="li1">
<input type="checkbox" id="ck2" name="cktypeid[2]" checked="checked"/> <a href="/manage/" target="_blank">运营</a> 
<input type="checkbox" id="ck3" name="cktypeid[3]" checked="checked"/> <a href="/school/" target="_blank">学院</a> [邮件订阅]
</li>
<li class="li1"><input name="email" type="text" size="25" value="请输入Email地址" onclick="if(this.value=='请输入Email地址') this.value='';" class="inp"/>
<input type="submit" name="dosubmit" value="订阅" class="btn" />
<input type="submit" name="dologout" value="退订" class="btn" />
</li>
<li class="li1">
<img src="/ui/2008/rss.gif" width="15" height="15" alt="模板RSS订阅"/> <a href="/manage/rss.xml">运营RSS订阅</a>  
<img src="/ui/2008/rss.gif" width="15" height="15"  alt="文摘RSS订阅"/> <a href="/school/rss.xml">学院RSS订阅</a>
</li>
</ul>
</form>
</div>
</div>
</div>
<div class="mn"> </div>
</div>
<div class="dsn" id="g300">
<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>
<div class="dsn" id="g468">
<script type="text/javascript">
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>
<script type="text/javascript">
$('gg300').innerHTML = $('g300').innerHTML;
$('gg468').innerHTML = $('g468').innerHTML;
</script>
<script type="text/javascript" src="/ui/2008/content.js"></script>
<script type="text/javascript" src="/school/show_js.php?itemid=539"></script>
<div style="display:none;">
<div id="member_js"><script type="text/javascript" src="http://bbs.master8.net/member.js.php"></script></div>
</div>
<div class="m">
<div class="b_8"> </div>
<div class="footer"><div class="f_r c_p"><img src="/ui/2008/spacer.gif" height="25" width="30" title="报告错误(本页最后更新时间:2008-10-09 11:43:41)" alt="" onclick="window.location='/about/contact.html';"/><img src="/ui/2008/spacer.gif" height="25" width="30" title="告诉好友" alt="" onclick="Tell();"/><img src="/ui/2008/spacer.gif" height="25" width="40" title="返回顶部" alt="" onclick="window.scrollTo(0,0);"/></div><a href="/" target="_blank">站长吧首页</a>
 | <a href="/service/" target="_blank">建站服务</a>
 | <a href="http://www.master8.net/service/adv.html" target="_blank">广告服务</a>
 | <a href="http://www.master8.net/about/contact.html" target="_blank">联系方式</a>
 | <a href="http://www.master8.net/about/agreement.html" target="_blank">使用协议</a>
 | <a href="http://www.master8.net/about/copyright.html" target="_blank">版权和隐私</a>
 | <a href="http://www.master8.net/sitemap/index.html" target="_blank">网站地图</a>
 | <a href="/member/register.php" target="_blank">新会员注册</a>
</div>
<div class="c_b">
<div class="foot"><span class="f_r"><select onchange="if(this.value) window.location=this.value;">
<option>--快速通道--</option>
<option value="/">网站首页</option>
<option value="/member/">会员中心</option>
<option value="http://home.master8.net/">会员列表</option>
<option value="http://bbs.master8.net/">站长论坛</option>
<option value="/manage/">网站运营</option>
<option value="/school/">技术学院</option>
<option value="/tool/">站长工具</option>
<option value="/service/">建站服务</option>
</select> </span>
©2005-2008 站长吧 Master8.NET All Rights Reserved 陕ICP备05010609号</div>
<div class="foot c_b"><a href="http://www.hosting.czm.cn/" target="_blank" title="九州未来科技，专业的主机提供商">九州未来科技提供服务器支持</a> | <a href="http://www.hosting.czm.cn/" target="_blank" title="网站空间">网站空间</a> | <a href="http://www.hosting.czm.cn/" target="_blank" title="虚拟主机">虚拟主机</a></div>
</div>
<br/>
</div>
<script type="text/javascript" src="/ui/2008/foot.js"></script>
<script type="text/javascript" src="/task.js.php?channelid=2&catid=22&itemid=539&page=0"></script>
</body>
</html>