使用SQLDMO可以完成Access和SqlServer等数据库的备份

public bool BackupDatabase(string DatabaseName,string BackupFile)
{
   SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
   SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
   try
   {
      oSQLServer.LoginSecure = false;
      oSQLServer.Connect("localhost", "sa", "");
      oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
      oBackup.Database = DatabaseName;
      oBackup.Files = BackupFile;
      oBackup.BackupSetName = DatabaseName;
      oBackup.BackupSetDescription = "数据库备份";
      oBackup.Initialize = true;
      oBackup.SQLBackup(oSQLServer);
      return true;
   }
   catch (System.Exception ex)
   {
      MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
      return false;
   }
   finally
   {
      oSQLServer.DisConnect();
   }
}

SQLDMO.DLL在SQL SERVER2000和2005中都是位于Microsoft SQL Server\80\Tools\Binn下