private void m3Button3_Click(object sender, EventArgs e)
{
string path = @"c:/Test.bak";
string backupstr = "backup database Test to disk='" + path + "';";
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;");
SqlCommand cmd = new SqlCommand(backupstr, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("备份成功!");
}
catch
{
MessageBox.Show("备份失败!");
}
finally
{
con.Close();
}
}
private void m3Button1_Click(object sender, EventArgs e)
{
string path = @"c:/Test.bak";
string restore = "restore database Test from disk='" + path + "';";
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;");
SqlCommand cmd = new SqlCommand(restore, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("恢复成功");
}
catch
{
MessageBox.Show("恢复失败");
}
finally
{
con.Close();
}
}
本机数据库的备份和还原,不能进行远程备份和还原。