asp.net 备份数据库

最新推荐文章于 2011-10-10 11:24:00 发布

assureo

最新推荐文章于 2011-10-10 11:24:00 发布

阅读量477

点赞数

分类专栏： asp.net 文章标签： asp.net button 数据库 server database object

asp.net 专栏收录该内容

36 篇文章 1 订阅

订阅专栏

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Admin_BackUPDB.aspx.cs" Inherits="Admin_Admin_BackUPDB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

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;
using SJW.Common;
using sqldmo;

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

}

    /// <summary>
    /// 数据库备份
    /// </summary>
    public static void DbBackup()
    {
        SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
        try
        {
            oSQLServer.LoginSecure = false;
            oSQLServer.Connect("localhost", "sa", "123");
            oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
            oBackup.Database = "DB_SJW";
            oBackup.Files = @"E:/DB_SJW.bak";
            oBackup.BackupSetName = "DB_SJW";
            oBackup.BackupSetDescription = "数据库备份";
            oBackup.Initialize = true;
            oBackup.SQLBackup(oSQLServer);
        }
        catch
        {
            throw;
        }
        finally
        {
            oSQLServer.DisConnect();
        }
    }
    /// <summary>
    /// 数据库恢复
    /// </summary>
public static void DbRestore()
{
   SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
   SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
   try
   {
    oSQLServer.LoginSecure = false;
    oSQLServer.Connect("localhost", "sa", "123");
    oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
    oRestore.Database = "DB_SJW";
    oRestore.Files = @"e:/DB_SJW.bak";
    oRestore.FileNumber = 1;
    oRestore.ReplaceDatabase = true;
    oRestore.SQLRestore(oSQLServer);
   }
   catch
   {
    throw;
   }
   finally
   {
    oSQLServer.DisConnect();
   }
}

    protected void Button1_Click(object sender, EventArgs e)
    {
        DbBackup();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        DbRestore();
    }
}

assureo

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
asp.net 备份数据库

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" > 无标题页 using System;using System.Data;using System.Configuration;using System
复制链接

扫一扫

专栏目录