sini65
یک شنبه 02 خرداد 1395, 19:17 عصر
من بانکم .mdf وقتی بک آپ می گبریم با موفقیت بک آپ می گیره ولی بعدش این خطا رو میده
140522
اینم کد برنامه ام
saveFileDialog1.FileName = DateTime.Now.ToString("ddmmyyyy-hhmmss");
saveFileDialog1.Filter = "backupfile(*.bak)|@.bak";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
this.Refresh();
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\hovzeh.mdf;Integrated Security=True;User Instance=True");
cmd.Connection.Open();
string dbname = cmd.Connection.Database;
cmd.Connection.Close();
SqlConnection.ClearAllPools();
string qure = "backup database[" + Application.StartupPath + @"\hovzeh.mdf] to disk='"+saveFileDialog1.FileName+"'";
cmd.Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True");
cmd.Connection.Open();
cmd.CommandText = qure;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
this.Refresh();
MessageBox.Show("ok");
140522
اینم کد برنامه ام
saveFileDialog1.FileName = DateTime.Now.ToString("ddmmyyyy-hhmmss");
saveFileDialog1.Filter = "backupfile(*.bak)|@.bak";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
this.Refresh();
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\hovzeh.mdf;Integrated Security=True;User Instance=True");
cmd.Connection.Open();
string dbname = cmd.Connection.Database;
cmd.Connection.Close();
SqlConnection.ClearAllPools();
string qure = "backup database[" + Application.StartupPath + @"\hovzeh.mdf] to disk='"+saveFileDialog1.FileName+"'";
cmd.Connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True");
cmd.Connection.Open();
cmd.CommandText = qure;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
this.Refresh();
MessageBox.Show("ok");