private void Backup(string filename)
{
SqlCoection con = null;
try
{
string Backup = @"Backup DataBase [NameDatabase] To Disk='" + filename + "'";
SqlCommand cmd = null;
con = new SqlCoection("Data Source=.;Initial Catalog=NameDatabase;Integrated Security=True");
con.Open();
cmd = new SqlCommand(Backup, con);
cmd.ExecuteNonQuery();
MessageBox.Show("پشتیبان گیری اطلاعات با موفقیت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
finally
{
con.Close();
}
}
private void btnBackUp_Click(object sender, EventArgs e)
{
SaveFileDialog SaveBackUp = new SaveFileDialog();
string filename = string.Empty;
SaveBackUp.OverwritePrompt = true;
SaveBackUp.Filter = @"SQL Backup Files ALL Files (*.*) |*.*| (*.Bak)|*.Bak";
SaveBackUp.DefaultExt = "Bak";
SaveBackUp.FilterIndex = 1;
SaveBackUp.FileName = DateTime.Now.ToString("dd-MM-yyyy_HH-mm-ss");
SaveBackUp.Title = "Backup SQL File";
if (SaveBackUp.ShowDialog() == DialogResult.OK)
{
filename = SaveBackUp.FileName;
Backup(filename);
}
}
برچسب: پشتیبان,
نویسنده: محمد رضا جوادیان