void BackUp(string ConnectionString, string DatabaseFullPath, string backUpPath) { progressBar1.Value = 0; using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); string UseMaster = "USE master"; SqlCommand UseMasterCommand = new SqlCommand(UseMaster, con); UseMasterCommand.ExecuteNonQuery(); progressBar1.Value += 25; string Alter1 = @"ALTER DATABASE [" + DatabaseFullPath + "] SET Single_User WITH Rollback Immediate"; SqlCommand Alter1Cmd = new SqlCommand(Alter1, con); Alter1Cmd.ExecuteNonQuery(); progressBar1.Value += 25; string Restore = @"BACKUP DATABASE [" + DatabaseFullPath + "] TO DISK = N'" + backUpPath + @"' WITH NOFORMAT, NOINIT, NAME = N'" + DatabaseFullPath + "-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"; SqlCommand RestoreCmd = new SqlCommand(Restore, con); RestoreCmd.ExecuteNonQuery(); progressBar1.Value += 25; string Alter2 = @"ALTER DATABASE [" + DatabaseFullPath + "] SET Multi_User"; SqlCommand Alter2Cmd = new SqlCommand(Alter2, con); Alter2Cmd.ExecuteNonQuery(); progressBar1.Value += 25; labelReport.Text = "Successful"; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)