yones136969
سه شنبه 01 مهر 1393, 10:42 صبح
سلام
من با sql express این کد برای restore نوشتم
openFileDialog1.ShowDialog();
SqlConnection cs = new SqlConnection("Data Source=.\\SQLEXPRESS; AttachDbFilename=" + Application.StartupPath + "\\mosque-maindb.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True");
SqlCommand cmds = new SqlCommand();
cmds.Connection = cs;
cs.Open();
//cmds.CommandText = "ALTER database mosque-maindb set single_user with rollback immediate" + " use master " + " RESTORE DATABASE mosque-maindb FROM DISK='" + openFileDialog1.FileName + "' with recovery ";
cmds.CommandText = "USE [master]; RESTORE DATABASE [" + Application.StartupPath + "\\mosque-maindb.mdf] FROM DISK = N'" + openFileDialog1.FileName + "' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10";
cmds.ExecuteNonQuery();
MessageBox.Show("successful Restor");
cs.Close();
اما این خطا رو میده
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
لطفا راهنمایی کنید.
من با sql express این کد برای restore نوشتم
openFileDialog1.ShowDialog();
SqlConnection cs = new SqlConnection("Data Source=.\\SQLEXPRESS; AttachDbFilename=" + Application.StartupPath + "\\mosque-maindb.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True");
SqlCommand cmds = new SqlCommand();
cmds.Connection = cs;
cs.Open();
//cmds.CommandText = "ALTER database mosque-maindb set single_user with rollback immediate" + " use master " + " RESTORE DATABASE mosque-maindb FROM DISK='" + openFileDialog1.FileName + "' with recovery ";
cmds.CommandText = "USE [master]; RESTORE DATABASE [" + Application.StartupPath + "\\mosque-maindb.mdf] FROM DISK = N'" + openFileDialog1.FileName + "' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10";
cmds.ExecuteNonQuery();
MessageBox.Show("successful Restor");
cs.Close();
اما این خطا رو میده
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.
لطفا راهنمایی کنید.