private void btnRestore_Click(object sender, EventArgs e)
{
string queryString = "use [master]\r\n select * from sysprocesses where dbid=DB_ID('dd')\r\n ";
InlineQuery query = DB.Query();
IDataReader SidList = query.ExecuteReader(queryString);
while (SidList.Read())
{
try
{
queryString = "kill " + SidList["spid"].ToString();
query.Execute(queryString);
}
catch
{
}
}
try
{
queryString = "use [master]\r\n RESTORE DATABASE DD FROM disk='" + this.tbxRestoreFile.Text + "'";
query.Execute(queryString);
MessageBox.Show("恢复成功", "提示信息");
}
catch
{
MessageBox.Show("恢复失败", "提示信息");
}
}
private void btnBackup_Click(object sender, EventArgs e)
{
try
{
string queryString = "Backup database DD to disk='" + this.tbxBackupFile.Text + "'";
InlineQuery query = DB.Query();
query.Execute(queryString);
MessageBox.Show("备份成功", "提示信息");
}
catch
{
MessageBox.Show("备份失败", "提示信息");
}
}
