iradata
شنبه 15 بهمن 1390, 16:49 عصر
سلام
من می خوام که از اطلاعات پشتیبان گرفته شده از بانکم Restore بگیرم اما در هنگام کار با این خطا رو به رو میشم
کدم :
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=" + Setting.Database.Default.Server + ";Initial Catalog=" + Setting.Database.Default.Database1 + ";Integrated Security=True";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string sql = "Restore Database [AjansDB] From Disk =N'" + txtPath.Text + "'";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
خطا :
RESTORE cannot process database 'AjansDB' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.
من می خوام که از اطلاعات پشتیبان گرفته شده از بانکم Restore بگیرم اما در هنگام کار با این خطا رو به رو میشم
کدم :
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=" + Setting.Database.Default.Server + ";Initial Catalog=" + Setting.Database.Default.Database1 + ";Integrated Security=True";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string sql = "Restore Database [AjansDB] From Disk =N'" + txtPath.Text + "'";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
خطا :
RESTORE cannot process database 'AjansDB' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.