以下是代码:
 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();
            }
问题是,数据库正在使用中,所以未能获得对数据库的排它访问权限??