Video Screencast Help
Backup and Recovery Community Blog

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

Created: 09 Jul 2009 • 7 comments
RahulG's picture
+3 3 Votes
Login to vote

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.

Comments 7 CommentsJump to latest comment

Masti24by7's picture

thats really helpful with the DLO option

0
Login to vote
jongeob's picture

I am having trouble with this procedure.  I was finally able to connect to the backup exec instance but I am not sure what I am supposed to enter on the line in bold below.  What is the syntax exactly (minus the computer name obviously).  Thanks for your help!

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

+1
Login to vote
HariDXB's picture

Hi, I am facing the same problem with my DLO installation. After entering the command " osql -E -S %COMPUTERNAME%\ bkupexec -d BE_DLO",   I get the following message.

[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

If you can understand something from it, please help me.

0
Login to vote
HariDXB's picture

I have installed SQL server Express 2005 on this server and not full installation of SQL server

Hari.

0
Login to vote
RahulG's picture

Check the database instance if it had been upgrade from older version it might be BKUPEXECDLO
Also make sure you specify the correct computer name ..in you case it would be the same name of your backup exec server
incase if you have issue could you post this in forums ...

0
Login to vote
HariDXB's picture

Databse instance iS BKUPEXEC ONLY.

0
Login to vote
Jo88's picture

I know this is an old thread but I am digging it back up anyway. So I am having a similar issue, and I have found the SQL for removing both users and computers which helped with deleting users who were no longer being backed up and it helped with deleting computers that were no longer being backed up.

Here is the problem though, I have computers that are no longer being used by a specific user, a user who still uses other machines, and the machine is still being used by other users. So if in these instances I cannot delete the entire user or the the entire computer I need to simply delete the job that is associated with a user and a computer.

example...

Backup Job 1. needs to be removed

Computer "A" > User "A"

Backup Job 2. needs to be kept

Computer "A" > User "B"

Backup Job 3. needs to be kept

Computer "B" > User "A"

As you can see I cannot delete either User "A", User "B", Computer "A", or Computer "B" but I need to delete Backup Job 1 because it is stuck in "delete pending". So how would I manually delete that job without deleting the user wholesale or the computer wholesale?

 

0
Login to vote