Today my database seems suspect. I am running SQL Server 2016 with memory tables. The below code won't work to fix the suspect. SQL Server keeps saying I have to restore. Any ideas?
EXEC sp_resetstatus dbname; ALTER DATABASE dbnameSET EMERGENCY DBCC checkdb(dbname) ALTER DATABASE dbnameSET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (dbname, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE dbnameSET MULTI_USER