mohsen_metn
چهارشنبه 23 بهمن 1387, 17:24 عصر
سلام
میدونم سوالم تکراریه ولی باور کنید تمام سایت رو گشتم ولی مشکلم حل نشد
من برای ریستور کردن دیتا بیس به این طریق عمل می کنم ولی خطا می ده:
openFileDialog1.ShowDialog();
string path = openFileDialog1.FileName.ToString();
MessageBox.Show(path);
SqlConnection connection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Data Source=.\SQLEXPRESS");
connection.Open();
string ad;
ad = "use master ";
ad = ad + " RESTORE DATABASE club ";
ad = ad + " FROM DISK = @path WITH RECOVERY, REPLACE ";
//ad = ad + " RETURN ";
SqlCommand comm = new SqlCommand(ad, connection);
comm.Parameters.AddWithValue("@path", openFileDialog1.FileName.ToString());
comm.ExecuteNonQuery();
connection.Close();
متن خطا
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
میدونم سوالم تکراریه ولی باور کنید تمام سایت رو گشتم ولی مشکلم حل نشد
من برای ریستور کردن دیتا بیس به این طریق عمل می کنم ولی خطا می ده:
openFileDialog1.ShowDialog();
string path = openFileDialog1.FileName.ToString();
MessageBox.Show(path);
SqlConnection connection = new SqlConnection(@"Integrated Security=SSPI;Persist Security Info=False;Data Source=.\SQLEXPRESS");
connection.Open();
string ad;
ad = "use master ";
ad = ad + " RESTORE DATABASE club ";
ad = ad + " FROM DISK = @path WITH RECOVERY, REPLACE ";
//ad = ad + " RETURN ";
SqlCommand comm = new SqlCommand(ad, connection);
comm.Parameters.AddWithValue("@path", openFileDialog1.FileName.ToString());
comm.ExecuteNonQuery();
connection.Close();
متن خطا
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.