数据库还原与备份的代码(1)

id="google_ads_frame2" height="250" marginheight="0" src="http://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-7690360365656368&output=html&h=250&slotname=7390388691&w=300&lmt=1275032139&flash=10.0.45.2&url=http%3A%2F%2Fwww.livingcode.cn%2Faspnet%2F201005%2F503.html&dt=1279503831234&shv=r20100711&prev_slotnames=0438657723&correlator=1279503831109&frm=0&adk=2788410769&ga_vid=1332730989.1279503831&ga_sid=1279503831&ga_hid=1941127283&ga_fc=0&u_tz=480&u_his=0&u_java=1&u_h=768&u_w=1024&u_ah=738&u_aw=1024&u_cd=32&u_nplug=0&u_nmime=0&biw=1007&bih=597&eid=36815001&ref=http%3A%2F%2Fwww.google.com.hk%2Fsearch%3Fhl%3Dzh-CN%26newwindow%3D1%26safe%3Dstrict%26q%3DSQL%25E8%25BF%2598%25E5%258E%259F%25E6%2595%25B0%25E6%258D%25AE%25E5%25BA%2593%25E7%259A%2584%25E4%25BB%25A3%25E7%25A0%2581%26aq%3Df%26aqi%3D%26aql%3D%26oq%3D%26gs_rfai%3D&fu=0&ifi=2&dtd=31&xpc=orczlr3lSn&p=http%3A//www.livingcode.cn" frameborder="0" width="300" allowtransparency="allowtransparency" name="google_ads_frame" marginwidth="0" scrolling="no" style="position: absolute; top: 0px; left: 0px">

使用如下代码 ASP.NET 备份和恢复 Sql Server 数据库,只需要拷贝下面源代码即可使用。

备份Sql Server数据库的代码:

string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "backup database " + this.DropDownList1.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); //建立SQL SERVER数据库连接
try 
{ 
if (File.Exists(this.TextBox1.Text.Trim())) 
{ 
Response.Write(" "); 
return; 
} 
SqlCommand com = new SqlCommand(SqlStr2, con); 
com.ExecuteNonQuery(); //备份SQL SERVER 数据库
Response.Write(" "); 
} 
catch (Exception error) 
{ 
Response.Write(error.Message); //输出备份 SQL SERVER 数据库时产生的错误信息
Response.Write(" "); 
} 
finally 
{ 
con.Close(); 
}

还原Sql Server数据库的代码：

string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称 
string dbname = this.DropDownList1.SelectedValue; 
string SqlStr1 = "Server=(local);database='" + this.DropDownList1.SelectedValue + "';Uid=sa;Pwd="; 
string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'"; 
SqlConnection con = new SqlConnection(SqlStr1); 
con.Open(); //建立SQL SERVER数据库连接
try 
{ 
SqlCommand com = new SqlCommand(SqlStr2, con); 
com.ExecuteNonQuery(); //还原SQL SERVER 数据库
Response.Write(" "); 
} 
catch (Exception error) 
{ 
Response.Write(error.Message); //输出还原 SQL SERVER 数据库时产生的错误信息
Response.Write(" "); 
} 
finally 
{ 
con.Close(); //关闭数据库连接
}