当前位置：文档库 › 数据库备份

数据库备份

C# code ?

1 2 3 4 5 6 7 8 9

29 private void btnBak_Click(object sender, EventArgs e) //备份

{

string saveAway = this.tbxBakLoad.Text.ToString().Trim();

string cmdText = @"backup database " + System.Configuration.Configurat

BakReductSql(cmdText,true);

}

private void btnReduct_Click(object sender, EventArgs e) //恢复

{

string openAway = this.tbxReductLoad.Text.ToString().Trim();//读取文件

string cmdText = @"restore database " + System.Configuration.Configura

BakReductSql(cmdText,false);

}

///

/// 对数据库的备份和恢复操作，Sql语句实现

///

/// 实现备份或恢复的Sql语句

/// 该操作是否为备份操作，是为true否，为false private void BakReductSql(string cmdText,bool isBak)

{

SqlCommand cmdBakRst = new SqlCommand();

SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=

try

{

conn.Open();

cmdBakRst.Connection = conn;

https://www.wendangku.net/doc/227597623.html,mandType = CommandType.Text;

if (!isBak) //如果是恢复操作

{

string setOffline = "Alter database GroupMessage Set Offline W

string setOnline = " Alter database GroupMessage Set Online Wi

https://www.wendangku.net/doc/227597623.html,mandText = setOffline + cmdText + setOnline;

}

else

{

https://www.wendangku.net/doc/227597623.html,mandText = cmdText;

}

cmdBakRst.ExecuteNonQuery();

if (!isBak)

{

MessageBox.Show("恭喜你，数据成功恢复为所选文档的状态！", "系统}

else

{

MessageBox.Show("恭喜，你已经成功备份当前数据！", "系统消息");

}

catch (SqlException sexc)

{

MessageBox.Show("失败，可能是对数据库操作失败，原因：" + sexc, "数}

catch (Exception ex)

{

MessageBox.Show("对不起，操作失败，可能原因：" + ex, "系统消息"); }

finally

{

cmdBakRst.Dispose();

conn.Close();

conn.Dispose();

}

caozhy caozhy 等级：

更多勋章#2

///

SqlConnection conn = new SqlConnection("Server=.;Database=master;User

SqlCommand cmdBK = new SqlCommand();

https://www.wendangku.net/doc/227597623.html,mandType = CommandType.Text;

cmdBK.Connection = conn;

https://www.wendangku.net/doc/227597623.html,mandText = @"backup database test to disk='C:\ba' with init";

try

{

conn.Open();

cmdBK.ExecuteNonQuery();

MessageBox.Show("Backup successed.");

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

conn.Close();

conn.Dispose();

}

///

///还原方法

///

SqlConnection conn = new SqlConnection("Server=.;Database=master;User conn.Open();

//KILL DataBase Process

SqlCommand cmd = new SqlCommand("SELECT spid FROM sysprocesses ;

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();

}

SqlCommand cmdRT = new SqlCommand();

https://www.wendangku.net/doc/227597623.html,mandType = CommandType.Text;

cmdRT.Connection = conn;

https://www.wendangku.net/doc/227597623.html,mandText = @"restore database test from disk='C:\ba'";

try

{

cmdRT.ExecuteNonQuery();

MessageBox.Show("Restore successed.");

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

conn.Close();

}

方法二（使用SQLDMO）：

///

///备份方法

///

SQLDMO.Backup backup = new SQLDMO.BackupClass();

SQLDMO.SQLServer server = new SQLDMO.SQLServerClass();

//显示进度条

SQLDMO.BackupSink_PercentCompleteEventHandler progress = new SQLD backup.PercentComplete += progress;

try

{

server.LoginSecure = false;

server.Connect(".", "sa", "sa");

backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Da backup.Database = "test";

backup.Files = @"D:\test\myProg\backupTest";

backup.BackupSetName = "test";

backup.BackupSetDescription = "Backup the database of test";

backup.Initialize = true;

backup.SQLBackup(server);

MessageBox.Show("Backup successed.");

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

server.DisConnect();

}

this.pbDB.Value = 0;

///

///还原方法

///

SQLDMO.Restore restore = new SQLDMO.RestoreClass();

SQLDMO.SQLServer server = new SQLDMO.SQLServerClass();

//显示进度条

SQLDMO.RestoreSink_PercentCompleteEventHandler progress = new SQLD restore.PercentComplete += progress;

//KILL DataBase Process

SqlConnection conn = new SqlConnection("Server=.;Database=master;User conn.Open();

SqlCommand cmd = new SqlCommand("SELECT spid FROM sysprocesses ;

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();

}

conn.Close();

try

{

server.LoginSecure = false;

server.Connect(".", "sa", "sa");

restore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_D restore.Database = "test";

restore.Files = @"D:\test\myProg\backupTest";

restore.FileNumber = 1;

restore.ReplaceDatabase = true;

restore.SQLRestore(server);

MessageBox.Show("Restore successed.");

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

server.DisConnect();

}

this.pbDB.Value = 0;

from: https://www.wendangku.net/doc/227597623.html,/html/bianchengkaifa/net/20090720/10592.html