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