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.
About Backup & Archiving Community Blog
The Backup & Archiving Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Backup & Archiving community. Any authenticated Connect member can contribute to this blog.
Comments
hi
thats really helpful with the DLO option
I am having trouble with this
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
Same Problem here
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.
I have installed SQL server
I have installed SQL server Express 2005 on this server and not full installation of SQL server
Hari.
Check the database instance
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 ...
If this response answers your concern, please mark it as a "solution"
Databse instance iS BKUPEXEC
Databse instance iS BKUPEXEC ONLY.
commercial walk in coolers
You can find a largest selection of commercial refrigeration and restaurant refrigeration equipments from leading manufacturers such as Kolpak, Master-Bilt and NorLake, at one stop, that is CKitchen.com. Some of the important kitchen equipments are restaurant walk-in cooler and freezers. Commercial walk in coolers are manufactured with 4" insulation foamed-in-place. According to the walk in cooler reviews, it is found that these coolers have gained popularity because of their reliability, outstanding performance, eco-friendly features and energy saving technology.
i did the same but there is
i did the same but there is an error showing anyway will try it again. thanks for the steps.
Bollywood Movies
Would you like to reply?
Login or Register to post your comment.