string path = "@";
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("192.168.1.7", "sa", "123456");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "cnc";
oBackup.Files = path;
oBackup.BackupSetName = "1.bak";
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oSQLServer.DisConnect();
}