以下是代码:
string path = FileUpload1.FileName.ToString();//获得备份路径及数据库名称
if (path == "")
{
Response.Write("<script language=javascript>alert('Please select a path!')</script>");
}
path = @"d:\Backup\" + path;
string dbname = this.DropDownList1.SelectedValue;//这是一个选择框来选择我要还原的数据库
string SqlStr1 = PubConstant.ConnectionString;//数据库连接字符串
string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'";//sql语句
SqlConnection con = new SqlConnection(SqlStr1);//创建连接
con.Open();
try
{
SqlCommand com = new SqlCommand(SqlStr2, con);
com.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('Restore data success!');location='Databack.aspx'</script>");
}
catch (Exception error)
{
// Response.Write(error.Message);
Response.Write("<script language=javascript>alert('Restore data failed!')</script>");
}
finally
{
con.Close();
}
问题是,数据库正在使用中,所以未能获得对数据库的排它访问权限??
string path = FileUpload1.FileName.ToString();//获得备份路径及数据库名称
if (path == "")
{
Response.Write("<script language=javascript>alert('Please select a path!')</script>");
}
path = @"d:\Backup\" + path;
string dbname = this.DropDownList1.SelectedValue;//这是一个选择框来选择我要还原的数据库
string SqlStr1 = PubConstant.ConnectionString;//数据库连接字符串
string SqlStr2 = "use master restore database " + dbname + " from disk='" + path + "'";//sql语句
SqlConnection con = new SqlConnection(SqlStr1);//创建连接
con.Open();
try
{
SqlCommand com = new SqlCommand(SqlStr2, con);
com.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('Restore data success!');location='Databack.aspx'</script>");
}
catch (Exception error)
{
// Response.Write(error.Message);
Response.Write("<script language=javascript>alert('Restore data failed!')</script>");
}
finally
{
con.Close();
}
问题是,数据库正在使用中,所以未能获得对数据库的排它访问权限??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货