Sample Header Ad - 728x90

In Memory Database Remove File and FileGroup

5 votes
2 answers
7123 views
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.
Asked by Banu Akkus (389 rep)
Jul 14, 2017, 12:30 PM
Last activity: Jul 1, 2022, 02:17 PM