(Warning! This is certainly not for the faint of heart and I’m pretty sure it’s not supported. Use at your own risk. I am not responsible for any damage caused.)
I recently renamed my existing backup server to a new name as I was replacing it with a stronger one. The big mistake I made was I didn’t shutdown the backup exec services and disable them first.
For whatever reason, I wasn’t able to export the information and was forced to copy the program files folder. Backup Exec changed the name for the media server to the new name. I didn’t notice this until I brought the it all over to the new system and discovered I now had two listed media devices; one with the proper server name and one with the old server renamed.
After reading that 2010 fixes this after a few service restarts I saw that it wasn’t helping.
I resorted to going into the SQL server part of it directly.
AGAIN, not for the faint of heart!
I shut down all bkexec services (and I could as no backup jobs were running.. hint hint). I stopped the SQL service long enough to copy the folder under program files. Restart the SQL service. Leave it running and note the name in brackets. ie BKUPEXEC. I didn’t have the MS SQL Server Management Studio installed locally. I have the app installed on another server and was able to run it from there.
For server name, you have to specify the namesql service info in brackets ie BACKUPSRVBkupexec
I left it as Windows Authentication as both machines were on the same domain. On the connection properties, set Connect to database to BEDB and click Connect.
Expand Databases -> BEDB -> Tables
We need these 3 tables: dbo.Device dbo.MachineDevice dbo.BackpToDiskFolder (if you use these)
Check dbo.Device and look for the name of your duplicate media device. Note the deviceID. ie 1000
(Before removing any rows, select the row, right click and copy, then paste into to notepad as a way to know what you had in case.)
If you use BackupToDisk folders, remove any rows with that deviceID.
After check dbo.MachineDevice and remove any entries with your deviceID (Again I copied the row into to notepad)
Finally do the same with dbo.Device and remove the duplicate. (Copy info to notepad).
(The notepad part if needed, would be a manual re-entry. Worse case, the copied program files folder could also save you. You would just need to stop all services including SQL)
The reason I do it in this order is that you will get errors if you start with the first as you would break references to the tables that follow.
Restart all your bkexec services and start Backup exec app. Your duplicate device should now be gone. Test carefully to make sure it all works before your backup window.