Backup Exec 12.5: Error "The Backup Exec Server Service detected a schema version mismatch."

You need to love Symantec...

I just did an update from Backup Exec 12.0 to 12.5. Since the last update (11 to 12.0) failed with a version schema error, I though this time I will wait until at least SP1 is available.

No guess what? Software installation okay, restarted the server and here we go again: The Backup Exec Server Service detected a schema version mismatch. ÜBERFAIL SYMANTEC!

Fortunately, the fix is nearly the same as the last time. Using SQL Server Management Studio, open the following files and execute them. Please remember to switch the database (normally it will say MASTER inside the tool bar) to the BEDB database before executing any of those.

#1: C:\Program Files\Symantec\Backup Exec\betopcat.sql
#2: C:\Program Files\Symantec\Backup Exec\dbupgrade12.0.sql
#3: C:\Program Files\Symantec\Backup Exec\dbupgrade12.0-viewandsp.sql

After that, everything should be fine.


Appendix:

To: Product manager of Backup Exec
From: TeX HeX
Subject: Whoever is in charge for the schema upgrade process within BE...

Fire him!

'nuff said.