private void BackUp()
{
try
{
SqlConnection.ClearAllPools();
SqlConnection cn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
cn.ConnectionString = "server=.;database=DataBase;integrated security=true";
cmd.Connection = cn;
cmd.CommandText = "BACKUP DATABASE Table TO DISK = 'Path.bak'";
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
catch(Exception x)
{
MessageBox.Show(x.Message);
}
}
private void Recover()
{
try
{
SqlConnection.ClearAllPools();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "server=.;database=master;integrated security=true";
SqlCommand cmd = new SqlCommand("use master; RESTORE DATABASE [Table] FROM DISK = 'Path.bak' with replace ", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
}