The problem is not that index already exists but there are duplicate values of the TopicShortName field in the table itself. Such duplicates prevent the creation of a UNIQUE index.
So you should run a query to confirm that you have a duplicate:
COUNT(*) > 1
Presumably in the other database the data are different, and the duplicates are not present.
This will certainly solve your problem.