Cannot delete Server under Devices. Symantec BE 2010 R2

[Scottle70]

Hi all,

After migration to the new server, I cannot delete the old server under Devices. I see the new server and I also see the old one.  Please help. Thank you.

[Backup_Exec1]

Hi

1 In this case you can use SQL studio if you dont have it please install it

2 Then open it & connect to bkupexec instance

3 Then right click on bedb & edit table

4 When table is opened you will see dbo.devices in that you will see the old server entry which you can remove

Please note

Before doing this you can take the backup of your backupexec database by stopping sql service & taking the backup of data folder & then starting sql service again & then doing the above steps

Thanks

[pkh · Accepted solution]

The old server name is not just in one table.  See the solution below on how to get rid of it.

https://www-secure.symantec.com/connect/forums/upgrading-125-2010-server-upgrade-2003-2008#comment-4...

[Scottle70]

Thank you very much PKH and BACKUP_EXEC. There are 3 tables needed to delele some entries relating to the old server. You cannot delete some entries in dbo.device until you have to delete the entries relate to db.DevicePool_Device and dbo.MachineDevice

dbo.device

dbo.DevicePool_Device

dbo.MachineDevice

[Ken_Putnam]

Symantec HIGHLY discourages manually mucking around in tbe BEDB

If you mess something up, you can completely destroy your backup system

[Scottle70]

Hi Ken,

I agree with you. Back up the database before deleting the entries. But with this situation, you have to manually to go the database and delete the entries.

[Nick_Elmer]

This is one side effect of moving between servers with different names. This is primarily the reason why in my blog (https://www-secure.symantec.com/connect/blogs/backup-exec-install-blog-upgrades) I recommend that you use the same server name. An additional issue you will likely encounter next is that the selection lists do not show check boxes at the root. After expanding them, then you will see check boxes. This has to do with how we store the selections internally. Because of potential data threatening risks, we cannot automate that step for you. So, you may also need to re-do your selection lists to have them display correctly as well.

Thanks,
Nick

[Scottle70]

Thanks Nick.