Before doing anything take backup

then

1- Delete memory optimized tables

2- Detach Database

3- Create new database with same files without memory optimized filegroup

4- Modify database files and change it to detached database (mdf,ldf,ndf) files

    alter database test1 modify file (name='test1' , filename='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\test.mdf')
    
    alter database test1 modify file (name='test1_log' , filename='C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\test_log.ldf')

5- Now try to to repair database:


    alter database test1 set emergency
    
    alter database test1 set single_user with ROLLBACK IMMEDIATE;
    
    dbcc checkdb(test1,repair_allow_data_loss)
    
    alter database test1 set multi_user
    
    alter database test1 set online

6- After successfully repair database remove memory optimized filegroup from database

 

    ALTER DATABASE [test1] REMOVE FILEGROUP [memory_optimized_filegroup_0]