private void btnBackup_Click(object sender, EventArgs e)
{
if (txtBackupPath.Text == string.Empty)
{
MessageBox.Show("Please Enter a backup File Location ");
}
else
{
string query = "BACKUP DATABASE [" + DBClass.DBName + "] TO DISK='" + txtBackupPath.Text + "\\" + "Database" + "-" + DateTime.Now.ToString("yyyy-MM-dd--HH-mm-ss") + ".bak'";
DBClass.ExecuteNonQuery(query);
MessageBox.Show("Backup taken Successfully", "Backup Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnBackup.Enabled = false;
}
}
private void btnRestore_Click(object sender, EventArgs e)
{
string sql1 = string.Format("ALTER DATABSE [" + DBClass.DBName + "] SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
DBClass.ExecuteNonQuery(sql1);
string SQL2 = string.Format("USE MASTER RESTORE DATABASE [" + DBClass.DBName + "] FROM DISK='" + txtRestorePath.Text + "' WITH REPLACE;");
DBClass.ExecuteNonQuery(SQL2);
string sql3 = string.Format("ALTER DATABSE [" + DBClass.DBName + "] SET MULTI_USER");
DBClass.ExecuteNonQuery(sql3);
MessageBox.Show("Database Restore Successfully", "Restore Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnRestore.Enabled = false;
}
