Backup Exec for Windows 2010 upgrade reports there was a problem upgrading the Backup Exec Device & Media Service and the Backup Exec services will not start.
During an upgrade from Backup Exec for Windows 11d, 12.0 , and 12.5 to Backup Exec for Windows 2010 the upgrade reports the following message at the end of the installation:
Database upgrade did not complete successfully. All devices, media and jobs will not be migrated from your prior version.
There was a problem upgrading the Backup Exec Device & Media Service
The following error is observed in the Application Log when attempting to start the Backup Exec services:
BEMIG:  VersionName = ADAMM 12.5, VersionNumber = 12.5000000000
BEMIG:  UpgradeTo13_000000
BEMIG:  SQL script name: C:\Program Files\Symantec\Backup Exec\AdammUpgrade126.sql
BEMIG:  [Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'AllocatedTo' in table 'PhysicalDisk' is specified more than once.
BEMIG:  , retval: 1
BEMIG:  There was a problem upgrading the Backup Exec Device & Media Service Database, version 12.500000.
This issue has been resolved with Hotfix 344584. (See the related documents for download information)
- Apply Backup Exec 2010 R1 Hotfix 344584 or Service Pack 1.
- Run BEMIG Migration Command line utility after creating the appropriate Upgrade and Upgrade Version Registry keys per Technote (TECH50537).
- Start the Backup Exec Services