Deleting the computer name from DLO console stuck in "Delete pending" state

Would like to share the SQL command that helped in deleting the computer name from DLO console stuck in "Delete pending" state.

The Cause of this is most likely to be the change in HostName of a Workstation.

NOTE: Use BEUTILITY to DUMP "backup" the DLO database. Copy saved database X:\program files\Symantec\backup exec\data\BE_DLO.BAK to a safe location.

The delete machine script deletes by MachineID so the first thing we have to do is find out the Machine ID.

NOTE: Clean installs of Backup Exec 11 and 12 will use the BKUPEXEC instance for both the BE database and the DLO database. Upgrades from previous versions will have separate instances and the DLO instance maybe BKUPEXECDLO. Verify the instance name is correct before running the commands below.

From a CMD prompt type the following:

osql -E -S %COMPUTERNAME%\ bkupexec -d BE_DLO

1> select MSID from MachineSettings where MSName = 'ComputerName'

2> GO

(NOTE: 'ComputerName' above = the Host Name of the Computer as it appears in DLO Console)

Then take the MachineID returned and type:

1> EXEC Delete_Machine 'MachineID'

e.g. EXEC Delete_Machine 43

2> GO

Launch DLO Console and confirm that Computer Account no longer shows "Delete Pending" State and is deleted.