数据库备份方法

public static void DbBackup()

{

    SQLDMO.Backup oBackup = new SQLDMO.BackupClass();

    SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();

    try

    {

        string strDateTime=System.DateTime.Now.ToString("yyyy-MM-dd");

        strDateTime=strDateTime.Replace("-","");

        oSQLServer.LoginSecure = false;

        oSQLServer.Connect("localhost", "sa", "");

        oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;

        oBackup.Database = "CEISData";

        //oBackup.Files = @"d:Northwind.bak";

        oBackup.Files=""+strDateTime+"CEISData.bak";

        oBackup.BackupSetName = "CEISData";

        oBackup.BackupSetDescription = "数据库备份";

        oBackup.Initialize = true;

        oBackup.SQLBackup(oSQLServer);

    }

    catch

    {

        throw;

    }

    finally

    {

        oSQLServer.DisConnect();

    }

}