• What happens if you try to create the primary key on the backup table?

    What is the result of the following query?

    SELECT AbcID, COUNT(*) FROM backuptable

    GROUP BY AbcID

    HAVING COUNT(*) > 1;

    Can you post the DDL for all three tables plus the script you're using to load the data into the backup table and the new table?