c#中数据库的备份和恢复

//数据备份菜单点击事件
private void mnuBackUp_Click(object sender, System.EventArgs e)
{
frmBackUp back=new frmBackUp(frmBackUp.SetType.BackUp);
back.Show();
//调用dll
BackUpAndReinstate.BackUp backup=new BackUpAndReinstate.BackUp(Application.StartupPath+"\BackUp\TeachingBusiness.bak");
string message=backup.DataBaseBackUp();
MessageBox.Show(message,"消息",MessageBoxButtons.OK,MessageBoxIcon.Information);
back.Close();
}
//数据恢复菜单点击事件
private void mnuReinstate_Click(object sender, System.EventArgs e)
{
frmBackUp back=new frmBackUp(frmBackUp.SetType.Reinstate);
back.Show();
//调用dll
BackUpAndReinstate.Reinstate reinstate=new BackUpAndReinstate.Reinstate();
string message=reinstate.DataBaseReinstate();
MessageBox.Show(message,"消息",MessageBoxButtons.OK,MessageBoxIcon.Information);
back.Close();
}
frmBackUp窗体代码：
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace 教务系统
{
/// <summary>
/// frmBackUp 的摘要说明。
/// </summary>
public class frmBackUp : System.Windows.Forms.Form
{
private System.Windows.Forms.Label label1;
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.Timer timer1;
private System.ComponentModel.IContainer components;
public enum SetType
{
BackUp,
Reinstate
}
private int type=0;
public frmBackUp(SetType settype)
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
this.type=(int)settype;
//
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmBackUp));
this.label1 = new System.Windows.Forms.Label();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.timer1 = new System.Windows.Forms.Timer(this.components);
this.SuspendLayout();
//
// label1
//
this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label1.Location = new System.Drawing.Point(8, 8);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(256, 64);
this.label1.TabIndex = 0;
this.label1.Text = "正在备份数据，请稍侯......";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(24, 16);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(64, 48);
this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;
this.pictureBox1.TabIndex = 1;
this.pictureBox1.TabStop = false;
//
// timer1
//
this.timer1.Interval = 300;
this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
//
// frmBackUp
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(272, 80);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.label1);
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Name = "frmBackUp";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "备份数据...";
this.Load += new System.EventHandler(this.frmBackUp_Load);
this.ResumeLayout(false);
}
#endregion
private void timer1_Tick(object sender, System.EventArgs e)
{
this.pictureBox1.Image.RotateFlip(RotateFlipType.Rotate90FlipXY);
this.pictureBox1.Refresh();
}
// public void setType(SetType)
// {
//
private void frmBackUp_Load(object sender, System.EventArgs e)
{
if(this.type==(int)SetType.BackUp)
this.label1.Text="正在备份数据，请稍侯......";
else if(this.type==(int)SetType.Reinstate)
this.label1.Text="正在恢复数据，请稍侯......";
this.timer1.Start();
}
}
}
BackUpAndReinstate组件中的类：(BackUp类和Reinstate类）
BackUp类：
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 数据备份类
/// </summary>
public class BackUp
{
private SqlConnection con=null; //数据库连接对象
private string filepath=null; //备份路径
//单参构造
public BackUp(string filepath)
{
con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
this.filepath=filepath;
}
//数据备份方法
public string DataBaseBackUp()
{
string str="";
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandText="select name from sysdevices where name='TeachingBusiness'";
con.Open();
SqlDataReader rdr=cmd.ExecuteReader();
if(!rdr.Read())
{
rdr.Close();
SqlCommand backcmd=new SqlCommand();
backcmd.Connection=con;
backcmd.CommandText="EXEC sp_addumpdevice @devtype,@logicalname,@physicalname";
SqlParameter param=backcmd.Parameters.Add("@devtype",SqlDbType.VarChar,20);
param.Value="disk";
param=backcmd.Parameters.Add("@logicalname",SqlDbType.VarChar,20);
param.Value="TeachingBusiness";
param=backcmd.Parameters.Add("@physicalname",SqlDbType.NVarChar,260);
param.Value=this.filepath;
backcmd.ExecuteNonQuery();
}
rdr.Close();
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
cmd.CommandText="backup database TeachingBusiness to TeachingBusiness";
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
finally
{
con.Close();
}
str="已备份成功！";
return str;
}
}
}
Reinstate类：
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 数据恢复类
/// </summary>
public class Reinstate
{
private SqlConnection con=null; //数据库连接对象
//默认构造
public Reinstate()
{
con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
}
//数据恢复方法
public string DataBaseReinstate()
{
string str="";
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandText="RESTORE DATABASE TeachingBusiness FROM TeachingBusiness with replace";
con.Open();
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
finally
{
con.Close();
}
str="已成功恢复数据库";
return str;
}
}
}
BackUpAndReinstate组件中的类：(BackUp类和Reinstate类）
BackUp类：
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 数据备份类
/// </summary>
public class BackUp
{
private SqlConnection con=null; //数据库连接对象
private string filepath=null; //备份路径
//单参构造
public BackUp(string filepath)
{
con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
this.filepath=filepath;
}
//数据备份方法
public string DataBaseBackUp()
{
string str="";
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandText="select name from sysdevices where name='TeachingBusiness'";
con.Open();
SqlDataReader rdr=cmd.ExecuteReader();
if(!rdr.Read())
{
rdr.Close();
SqlCommand backcmd=new SqlCommand();
backcmd.Connection=con;
backcmd.CommandText="EXEC sp_addumpdevice @devtype,@logicalname,@physicalname";
SqlParameter param=backcmd.Parameters.Add("@devtype",SqlDbType.VarChar,20);
param.Value="disk";
param=backcmd.Parameters.Add("@logicalname",SqlDbType.VarChar,20);
param.Value="TeachingBusiness";
param=backcmd.Parameters.Add("@physicalname",SqlDbType.NVarChar,260);
param.Value=this.filepath;
backcmd.ExecuteNonQuery();
}
rdr.Close();
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
cmd.CommandText="backup database TeachingBusiness to TeachingBusiness";
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
finally
{
con.Close();
}
str="已备份成功！";
return str;
}
}
}
Reinstate类：
using System;
using System.Data;
using System.Data.SqlClient;
namespace BackUpAndReinstate
{
/// <summary>
/// 数据恢复类
/// </summary>
public class Reinstate
{
private SqlConnection con=null; //数据库连接对象
//默认构造
public Reinstate()
{
con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local)");
}
//数据恢复方法
public string DataBaseReinstate()
{
string str="";
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandText="RESTORE DATABASE TeachingBusiness FROM TeachingBusiness with replace";
con.Open();
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException er)
{
str=er.Message;
return str;
}
finally
{
con.Close();
}
str="已成功恢复数据库";
return str;
}
}
}