Smoke_1110
شنبه 10 اردیبهشت 1390, 19:05 عصر
سلام
من هر وقت می خوام از بانکم پشتیبان بگیرم این ارور رو میده به نظر شما ایراد از کجاست ؟ اینم اون کدی هست که براش نوشتم
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string command = @"BACKUP DATABASE [" + Application.StartupPath + "\\Mashmolins.mdf] TO DISK = N'" + saveFileDialog1.FileName + "' WITH FORMAT, INIT, NAME = N'accounting-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";
this.Cursor = Cursors.WaitCursor;
SqlConnection objconnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Mashmolin.mdf;Integrated Security=True;User Instance=True");
SqlCommand oCommand = null;
if (objconnection.State != ConnectionState.Open)
objconnection.Open();
oCommand = new SqlCommand(command, objconnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
objconnection.Close();
MessageBox.Show("فایل پشتیبان ذخیره شد.", "پیغام");
oCommand.Dispose();
}
این هم اون ارور هست:
An attempt to attach an auto-named database for file F:\Computer\Computer\DataBase\Mashmolin\VER 5\Mashmolin\Mashmolin\bin\Debug\Mashmolin.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
من هر وقت می خوام از بانکم پشتیبان بگیرم این ارور رو میده به نظر شما ایراد از کجاست ؟ اینم اون کدی هست که براش نوشتم
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string command = @"BACKUP DATABASE [" + Application.StartupPath + "\\Mashmolins.mdf] TO DISK = N'" + saveFileDialog1.FileName + "' WITH FORMAT, INIT, NAME = N'accounting-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10";
this.Cursor = Cursors.WaitCursor;
SqlConnection objconnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Mashmolin.mdf;Integrated Security=True;User Instance=True");
SqlCommand oCommand = null;
if (objconnection.State != ConnectionState.Open)
objconnection.Open();
oCommand = new SqlCommand(command, objconnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
objconnection.Close();
MessageBox.Show("فایل پشتیبان ذخیره شد.", "پیغام");
oCommand.Dispose();
}
این هم اون ارور هست:
An attempt to attach an auto-named database for file F:\Computer\Computer\DataBase\Mashmolin\VER 5\Mashmolin\Mashmolin\bin\Debug\Mashmolin.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.