کد پشتیبان گیری من:
Shamsi.Shamsi sh = new Shamsi.Shamsi();
string[] m = sh.ShamsiDate().Split('/');
string h = m[0].ToString() + "-" + m[1].ToString() + "-" + m[2].ToString();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.AddExtension = true;
saveFileDialog.CheckFileExists = false;
saveFileDialog.CheckPathExists = true;
saveFileDialog.OverwritePrompt = true;
saveFileDialog.FileName = "Backup " + h;
saveFileDialog.Filter = "Backup File (*.Bak)|*.Bak";
saveFileDialog.DefaultExt = "Bak";
saveFileDialog.RestoreDirectory = true;
saveFileDialog.InitialDirectory = "//192.168.0.1 \\Backup";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
try
{
this.Refresh();
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"Data Source=192.168.0.1;Initial Catalog=DBFANO;User ID=ali;Password=010203 ");
SqlConnection.ClearAllPools();
cmd.Connection.Open();
string dbname = cmd.Connection.Database;//گرفتن نام دیتابیس
SqlConnection.ClearAllPools();
string query = "BACKUP DATABASE [" + dbname + "] TO DISK ='" + saveFileDialog.FileName + "' WITH NOFORMAT, NOINIT, NAME = N'DBFANO-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";
cmd.Connection = new SqlConnection(@"Data Source=192.168.0.1;Initial Catalog=DBFANO;User ID=ali;Password=010203");
cmd.Connection.Open();
cmd.CommandText = query;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
this.Refresh();
MessageBox.Show("نسخه پشتيبان به طور كامل ايجاد شد ", "پيام ", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign);
}
catch
{
MessageBox.Show("ايجاد نسخه پشتيبان با خطا مواجه گرديد ", " پيام ", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign);
}
}