asp.net 在线备份SQL数据库

BackUpDB.aspx

<div>
    
        备份数据库：<asp:DropDownList ID="db" runat="server">
        </asp:DropDownList>
        <br />
        <br />
    
    </div>
    <div>
    
        备份名称和位置：<asp:TextBox ID="positions" runat="server"></asp:TextBox>
        <br />
        <asp:Button ID="btBK" runat="server" onclick="btBK_Click" Text="开始备份" />
    <br />

    </div>

BackUpDB.aspx.cs

protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                BindDB();
            }
        }

        private void BindDB()
        {
            DataSet ds = SQLHelper.Query ("Exec sp_helpdb");
            db.DataSource = ds;
            db.DataTextField = "name";
            db.DataBind();
        }

        protected void btBK_Click(object sender, EventArgs e)
        {
            string SQL_STR = "backup database " + db.SelectedValue + " to disk='" + positions.Text.Trim() + ".bak'";
            try
            {
                if (File.Exists(positions.Text.Trim()))
                {
                    Response.Write("<script>alert('此文件己存在，请重新输入!');location='BackUpDB.aspx'</script>");
                    return;
                }
                SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStr, CommandType.Text, SQL_STR, null);
                Response.Write("<script>alert('备份数据成功!');location='BackUpDB.aspx'</script>");
            }
            catch (Exception ee)
            {
                Response.Write(ee.Message);
                Response.Write("<script>alert('备份数据库失败!')</script>");
            }
            
        }