How to Remove File and FileGroup from In-Memory Database in SQL Server

in-memory-databasesql serversql-server-2016

I have a SQL Server 2016 database and I configured in-memory table.
I want to drop this configuration, then I drop that table.
When I want to delete that file and filegroup, I got following error.

USE [InMem_Test]
GO
ALTER DATABASE [InMem_Test]  REMOVE FILE [InMemFile]
GO
ALTER DATABASE [InMem_Test] REMOVE FILEGROUP [InMemFileGroup]
GO

Msg 41802, Level 16, State 1, Line 3 Cannot drop the last
memory-optimized container 'InMemFile'. Msg 5042, Level 16, State 11,
Line 5 The filegroup 'InMemFileGroup' cannot be removed because it is
not empty.

Best Answer

Currently, the only way to remove Hekaton is to drop the whole database.

Probably not your first choice, but it doesn't look like Microsoft is willing to change course on that.

Related Question