private void bRestaurar_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbCaminhoRestauracao.Text))
{
BancoDataContext banco = new BancoDataContext("Data Source=lab5-prof;Initial Catalog=Master;User ID=sa;Password=1234");
try
{
banco.Connection.Open();
StringBuilder sql = new StringBuilder();
sql.Append(@"ALTER DATABASE [Banco] SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
banco.ExecuteCommand(sql.ToString());
sql.Clear();
sql.AppendFormat("RESTORE DATABASE [Banco] FROM DISK = '{0}'", tbCaminhoRestauracao.Text);
banco.ExecuteCommand(sql.ToString());
sql.Clear();
sql.Append("ALTER DATABASE [Banco] SET MULTI_USER");
banco.ExecuteCommand(sql.ToString());
MessageBox.Show("Restauração realizado com sucesso.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
banco.Connection.Close();
}
}
}
private void bBackup_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tbCaminhoBackup.Text))
{
BancoDataContext banco = new BancoDataContext("Data Source=lab5-prof;Initial Catalog=Master;User ID=sa;Password=1234");
try
{
banco.Connection.Open();
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"BACKUP DATABASE [{0}] TO DISK = '{1}\{0}_{2:yyyyMMdd_HHmmss}.bak'", "Banco", tbCaminhoBackup.Text, DateTime.Now);
banco.ExecuteCommand(sql.ToString());
MessageBox.Show("Backup realizado com sucesso.");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
banco.Connection.Close();
}
}
}