数据备份

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
///DbOper 的摘要说明
/// </summary>
public class DbOper
{
 public DbOper()
 {
  //
  //TODO: 在此处添加构造函数逻辑
  //
    }///<summary>
    /// 数据库备份
    ///</summary>
    public static void DbBackup()
    {
        SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
        try
        {
            oSQLServer.LoginSecure = false;
            oSQLServer.Connect("192.168.0.2", "sa", "XXXX");
            oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
            oBackup.Database = "DB_MVS";
            oBackup.Files = @"d:/DB_MVS.bak";
            oBackup.BackupSetName = "DB_MVS";
            oBackup.BackupSetDescription = "数据库备份";
            oBackup.Initialize = true;
            oBackup.SQLBackup(oSQLServer);
        }
        catch
        {
            throw;
        }
        finally
        {
            oSQLServer.DisConnect();
        }
    }
}