Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //to do DB backup
- private void spid2_Click(object sender, EventArgs e)
- {
- string SQLDataBases;
- SQLDataBases = "select @@spid ";
- SQLDataBases += "BACKUP DATABASE School TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorks333.BAK' ";
- string svr = "Server=" + localsrv + ";Initial Catalog=master;Integrated Security = SSPI;";
- SqlConnection cnBk = new SqlConnection(svr);
- Command = new SqlCommand(SQLDataBases, cnBk);
- Command.CommandText = SQLDataBases;
- SqlDataAdapter da = new SqlDataAdapter(Command);
- DataTable dtDatabases = new DataTable();
- try
- {
- cnBk.Open();
- da.Fill(dtDatabases);
- label1.Text = dtDatabases.Rows[0][0].ToString();
- }
- catch (Exception ex)
- {
- string s = ex.ToString();
- MessageBox.Show(s);
- label1.Text = dtDatabases.Rows[0][0].ToString();
- }
- finally
- {
- if (cnBk.State == ConnectionState.Open)
- {
- cnBk.Close();
- cnBk.Dispose();
- }
- }
- }
- //to kill backup session
- private void kill_Click(object sender, EventArgs e)
- {
- string SQLRestor;
- SQLRestor = "Use master; kill " + label1.Text;
- string svr = "Server=" + localsrv + ";Initial Catalog=master;Integrated Security = SSPI;";
- SqlConnection cnRestore = new SqlConnection(svr);
- SqlCommand cmdBkUp = new SqlCommand(SQLRestor, cnRestore);
- try
- {
- cnRestore.Open();
- cmdBkUp.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- string s = ex.ToString();
- }
- finally
- {
- if (cnRestore.State == ConnectionState.Open)
- {
- cnRestore.Close();
- cnRestore.Dispose();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement