Oops forgot to resolve this – what happened for reference if anyone is using UpDraftPlus
There was a misconfiguration between the demo site and live site with UpdraftPlus. After going through each backup from them we found the one that had all the info we needed. Best 4 hours of my life.