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
Last activity: Jul 1, 2022, 02:17 PM