ASP.NET备份、还原SQL Server数据库

一、备份SQL Server数据库


<span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> SqlStr1 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">Server=(local);database=''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.DropDownList1.SelectedValue </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">'';Uid=sa;Pwd=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;
</span><span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> SqlStr2 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">backup database </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.DropDownList1.SelectedValue </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> to disk=''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.TextBox1.Text.Trim() </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">.bak''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;
SqlConnection con </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> SqlConnection(SqlStr1);
con.Open();
</span><span style="COLOR: #0000ff">try</span><span id="_287_622_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_287_622_Open_Text"><span style="COLOR: #000000">{
    </span><span style="COLOR: #0000ff">if</span><span style="COLOR: #000000"> (File.Exists(</span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.TextBox1.Text.Trim()))
    </span><span id="_335_450_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_335_450_Open_Text"><span style="COLOR: #000000">{
        Response.Write(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"><script language=javascript>alert(''此文件已存在，请从新输入！'');location=''Default.aspx''</script></span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);</span><span style="COLOR: #0000ff">return</span><span style="COLOR: #000000">;
    }</span></span><span style="COLOR: #000000">
    SqlCommand com </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> SqlCommand(SqlStr2, con);
    com.ExecuteNonQuery();
    Response.Write(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"><script language=javascript>alert(''备份数据成功！'');location=''Default.aspx''</script></span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
}</span></span><span style="COLOR: #000000">
</span><span style="COLOR: #0000ff">catch</span><span style="COLOR: #000000"> (Exception error)
</span><span id="_648_754_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_648_754_Open_Text"><span style="COLOR: #000000">{
    Response.Write(error.Message);Response.Write(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"><script language=javascript>alert(''备份数据失败！'')</script></span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
}</span></span><span style="COLOR: #000000">
</span><span style="COLOR: #0000ff">finally</span><span style="COLOR: #000000">
</span><span id="_764_780_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_764_780_Open_Text"><span style="COLOR: #000000">{
    con.Close();
}</span></span> 二、还原SQL Server数据库


<span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> path </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.FileUpload1.PostedFile.FileName; 
</span><span style="COLOR: #008000">//</span><span style="COLOR: #008000">获得备份路径及数据库名称</span><span style="COLOR: #008000">
</span><span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> dbname </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.DropDownList1.SelectedValue;
</span><span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> SqlStr1 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">Server=(local);database=''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">this</span><span style="COLOR: #000000">.DropDownList1.SelectedValue </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">'';Uid=sa;Pwd=</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;
</span><span style="COLOR: #0000ff">string</span><span style="COLOR: #000000"> SqlStr2 </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">use master restore database </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> dbname </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> from disk=''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> path </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000"> </span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">''</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">;
SqlConnection con </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> SqlConnection(SqlStr1);
con.Open();
</span><span style="COLOR: #0000ff">try</span><span id="_368_540_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_368_540_Open_Text"><span style="COLOR: #000000">{
    SqlCommand com </span><span style="COLOR: #000000">=</span><span style="COLOR: #000000"> </span><span style="COLOR: #0000ff">new</span><span style="COLOR: #000000"> SqlCommand(SqlStr2, con);
    com.ExecuteNonQuery();
    Response.Write(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"><script language=javascript>alert(''还原数据成功！'');location=''Default.aspx''</script></span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
}</span></span><span style="COLOR: #000000">
</span><span style="COLOR: #0000ff">catch</span><span style="COLOR: #000000"> (Exception error)
</span><span id="_566_672_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_566_672_Open_Text"><span style="COLOR: #000000">{
    Response.Write(error.Message);Response.Write(</span><span style="COLOR: #000000">"</span><span style="COLOR: #000000"><script language=javascript>alert(''还原数据失败！'')</script></span><span style="COLOR: #000000">"</span><span style="COLOR: #000000">);
}</span></span><span style="COLOR: #000000">
</span><span style="COLOR: #0000ff">finally</span><span style="COLOR: #000000">
</span><span id="_682_698_Closed_Text" style="BORDER-RIGHT: #808080 1px solid; BORDER-TOP: #808080 1px solid; DISPLAY: none; BORDER-LEFT: #808080 1px solid; BORDER-BOTTOM: #808080 1px solid; BACKGROUND-COLOR: #ffffff">...</span><span id="_682_698_Open_Text"><span style="COLOR: #000000">{
    con.Close();
}</span></span>

您可能感兴趣的文章：
asp.net实现备份与恢复Sql Server数据库
SQL SERVER 2008 的数据库还原问题
mssql数据库备份与恢复实例
ASP.NET中备份SQL Server数据库的方法
php Mysql数据库备份类及调用方法
MySQL常用配置方法
mysql数据库备份常用命令示例
创建ASP.NET数据存储层(1)
c# 备份与还原SQL/ACCESS 数据库的代码
mysql备份还原后中文乱码的解决办法