数据备份与还原

using System;
using System.Collections.Generic;
using ponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
//数据备份
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=.\\SQLEXPRESS;Database=stuDB;Integrated security = sspi");
string filename = Application.StartupPath + "\\stuDB.bak";
SqlCommand cmdBK = new SqlCommand("backup database stuDB to disk ='"+filename+"'", conn);
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
MessageBox.Show("Backup successed.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
// MessageBox.Show(Application.StartupPath); //该解决方案执行文件所在路径
}
//数据还原
private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new
SqlConnection("Server=.\\SQLEXPRESS;Database=master;Integrated security = sspi");
conn.Open();
//KILL DataBase Process
SqlCommand cmd = new SqlCommand("SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND ='stuDB'", conn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
ArrayList list = new ArrayList();
while(dr.Read())
{
list.Add(dr.GetInt16(0));
}
dr.Close();
for(int i = 0; i < list.Count; i++)
{
cmd = new SqlCommand(string.Format("KILL {0}", list), conn);
cmd.ExecuteNonQuery();
}
string filename = Application.StartupPath + "\\stuDB.bak";
SqlCommand cmdRT = new SqlCommand(@"restore database stuDB from disk ='" + filename + "'", conn);
try
{
cmdRT.ExecuteNonQuery();
MessageBox.Show("Restore successed.");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
}
}
}。