databackup.aspx.cs

来自「一个土地管理系统」· CS 代码 · 共 64 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class manage_DataBackup : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Backup_Click(object sender, EventArgs e)
    {
        string bakname = TextBox1.Text;
        string serverIp = System.Configuration.ConfigurationManager.AppSettings["ServerIP"].ToString();
        string loginName = System.Configuration.ConfigurationManager.AppSettings["LoginName"].ToString();
        string loginPass = System.Configuration.ConfigurationManager.AppSettings["LoginPass"].ToString();
        string BackPath = Server.MapPath("../DataBak/"+bakname);
        string dbname = System.Configuration.ConfigurationManager.AppSettings["DBName"].ToString();
        SQLBACK(serverIp, loginName, loginPass, dbname, BackPath);
        Page.RegisterClientScriptBlock("clientScript","<script>alert('[操作成功]');</script>");
    }
    /// <summary>
    /// SQL数据库备份
    /// </summary>
    /// <param name="ServerIP">SQL服务器IP或(Localhost)</param>
    /// <param name="LoginName">数据库登录名</param>
    /// <param name="LoginPass">数据库登录密码</param>
    /// <param name="DBName">数据库名</param>
    /// <param name="BackPath">备份到的路径</param>
    void SQLBACK(string ServerIP, string LoginName, string LoginPass, string DBName, string BackPath)
    {
        SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
        try
        {
            oSQLServer.LoginSecure = false;
            oSQLServer.Connect(ServerIP, LoginName, LoginPass);
            oBackup.Database = DBName;
            oBackup.Files = BackPath;
            oBackup.BackupSetName = DBName;
            oBackup.BackupSetDescription = "数据库备份";
            oBackup.Initialize = true;
            oBackup.SQLBackup(oSQLServer);

        }
        catch (Exception e)
        {
            throw new Exception(e.ToString());
        }
        finally
        {
            oSQLServer.DisConnect();
        }
    }

}