backup.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;
using DbPrvd;

public partial class backup : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["User"] == null || Session["Role"] == null)
            Response.Write("<script type='text/javascript'>parent.document.location='timeout.htm';</script>");
        if (Session["Role"].ToString() != "管理员")
        {
            Response.Write("<script type='text/javascript'>alert('您无权操作');history.go(-1);</script>");
        }
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string path = Server.MapPath(".");
        path += "/DataBackup/";
        string datename = System.DateTime.Now.ToString("yyyyMMddhhmmss");
        string backupQuery = "backup database mall to disk='" + path +"mall_"+ datename + ".bak'";
        try
        {
            DB.ExecuteNonQuery(backupQuery);
            Response.Write("<script type='text/javascript'>alert('操作成功');</script>");
        }
        catch (Exception error)
        {
            Response.Write(error.Message);
            Response.Write("<script language=javascript>alert('备份数据失败！')</script>");
        }
    }
}