web数据库备份恢复

using System; 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.Data; using System.Configuration; using System.Collections

using System;
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.Data;
using System.Configuration;
using System.Collections;

namespace WebApplication1
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
//引用Web.config的数据库连接字符串　优点：数据库移植的时候可直接对Web.config的数据库连接字符串中的IP进行更换.
string con_str = ConfigurationManager.ConnectionStrings["testConnectionString"].ToString();
SqlConnection conn = new SqlConnection(con_str);
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database "+tbDB.Text.Trim()+@" to disk='..\Backup\"+tbBack.Text.Trim()+@".bak'" + " with init";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
System.Web.HttpContext.Current.Response.Write("");
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("");
}
finally
{
conn.Close();
}

}

protected void Button2_Click(object sender, EventArgs e)
{
//SqlConnection conn = new SqlConnection("Server=.;Database=master;User ID=sa;Password=1;Trusted_Connection=False");
//conn.Open();

//引用Web.config的数据库连接字符串　优点：数据库移植的时候可直接对Web.config的数据库连接字符串中的IP进行更换.
string con_str = ConfigurationManager.ConnectionStrings["testConnectionString"].ToString();
SqlConnection conn = new SqlConnection(con_str);
try
{
conn.Open();

//杀死所有正在使用要还原数据的数据库进程
SqlCommand cmd = new SqlCommand(@"use master SELECT spid FROM sysprocesses,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='" + tbHFDB0.Text.Trim() + "'", conn);

SqlDataReader dr;

dr = cmd.ExecuteReader();
ArrayList list = new ArrayList();
while (dr.Read())
{
list.Add(dr.GetInt16(0));
}
dr.Close();
for (int k = 0; k < list.Count; k++)
{
cmd = new SqlCommand(string.Format("KILL {0}", list[k]), conn);
cmd.ExecuteNonQuery();
}

SqlCommand cmdRT = new SqlCommand();
cmdRT.CommandType = CommandType.Text;
cmdRT.Connection = conn;
cmdRT.CommandText = @"use master restore database " + tbHFDB0.Text.Trim() + @" from disk= '..\Backup\" + tbHFfile.Text.Trim() + @".bak'" + " WITH REPLACE";
cmdRT.ExecuteNonQuery();
System.Web.HttpContext.Current.Response.Write("");
}
catch (Exception)
{
System.Web.HttpContext.Current.Response.Write("");
}
finally
{
conn.Close();
}
}
}
}