用A.NET 恢复备份Sql server(2)_.NET概论及软件使用_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

用A.NET 恢复备份Sql server(2)

作者:黑客防线网安ASP维护基地 来源:黑客防线网安ASP维护基地 浏览次数:0

本篇关键词:备份恢复'using
黑客防线网安网讯:   ystem;  using System.Collections.Generic;  using System.Linq;  using System.Web;  using System.Web.UI;  using System.Web.UI.WebControls;  using System.Data.SqlCl...

   ystem;

  using System.Collections.Generic;

  using System.Linq;

  using System.Web;

  using System.Web.UI;

  using System.Web.UI.WebControls;

  using System.Data.SqlClient;

  using System.IO;

  using System.Data;

  using System.Diagnostics;

  namespace SysSourceMgmt

  {

  public partial class SqlDbMgmt : System.Web.UI.Page

  {

  protected void Page_Load(object sender, EventArgs e)

  {

  if (!IsPostBack)

  {

  try

  {

  string SqlStr1 = "Server=(local);DataBase=master;Uid=sa;Pwd=";

  string SqlStr2 = "Exec sp_helpdb";

  SqlConnection con = new SqlConnection(SqlStr1);

  con.Open();

  SqlCommand com = new SqlCommand(SqlStr2, con);

  SqlDataReader dr = com.ExecuteReader();

  this.DropDownList1.DataSource = dr;

  this.DropDownList1.DataTextField = "name";

  this.DropDownList1.DataBind();

  dr.Close();

  con.Close();

  SqlStr1 = "Server=(local);DataBase=master;Uid=sa;Pwd=";

  SqlStr2 = "Exec sp_helpdb";

  con = new SqlConnection(SqlStr1);

  con.Open();

  com = new SqlCommand(SqlStr2, con);

  dr = com.ExecuteReader();

  this.DropDownList1.DataSource = dr;

  this.DropDownList1.DataTextField = "name";

  this.DropDownList1.DataBind();

  dr.Close();

  con.Close();

  }

  catch (Exception)

  {

  }

  }

  }

  protected void Button1_Click(object sender, EventArgs e)

  {

  string dbName = string.Empty;

  if (DropDownList1.Items.Count != 0)

  {

  dbName = DropDownList1.SelectedValue.Trim();

  }

  else

  {

  dbName = txtDbName.Text.Trim();

  }

  string SqlStr1 = "Data Source=.\sqlexpress;Initial Catalog='" + dbName + "';Integrated Security=True";

  string SqlStr2 = "backup database " + dbName + " to disk='" + this.TextBox1.Text.Trim() + ".bak'";

  SqlConnection con = new SqlConnection(SqlStr1);

  con.Open();

  try

  {

  if (File.Exists(this.TextBox1.Text.Trim()))

  {

  Response.Write("<script language=javascript>alert('此文件已存在请从新输入!');location='Default.aspx'</script>");

  return;

  }

  SqlCommand com = new SqlCommand(SqlStr2, con);

  com.ExecuteNonQuery();

  Response.Write("<script language=javascript>alert('备份数据成功!');'</script>");

  }

  catch (Exception error)

  {

  Response.Write(error.Message);

  Response.Write("<script language=javascript>alert('备份数据失败!')</script>");

  }

  finally

  {

  con.Close();

  }

  }

  protected void Button2_Click(object sender, EventArgs e)

  {

  string path = this.FileUpload1.PostedFile.FileName; //获得备份路径及数据库名称

  string dbName = string.Empty;

  if (DropDownList1.Items.Count != 0)

  {

  dbName = DropDownList1.SelectedValue.Trim();

  }

 

 

    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-14333-1.html
网站维护教程更新时间:2012-03-30 05:46:02  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer