So I managed to recreate the database by repointing the data files and then dropping the memory optimised filegroup.
Everything seemed ok, except the loginfo showed that entries were all at status 2 and the log would not free up.
I switched to simple recovery but no change to the log.
No open transactions and no log_reuse_wait_desc.
When I attempted to rebuild the log, it would not let me saying it does not support memory optimized tables.
Why does it still think there are memory optimized tables?
Is there a config file somewhere I can edit?
What else can I try to deal with log issue?
I might look into copying the data into a new db by table but would rather not
Any advise would be welcome.
TIA