remove filegroup, file

MKH 1 Reputation point
2020-06-30T01:39:54.36+00:00

I tried deleting files and filegroups. But it is not deleted. Need help...T T

do not remove file, filegroup and filestream

DBCC SHRINKFILE(FILENAME,EMPTYFILE)

DBCC SHRINKFILE for A_MOD_1 is aborting. MEMORY_OPTIMIZED_DATA container is not supported.

ALTER DATABASE A

REMOVE FILE A_MOD_1

The final container A_MOD_1 optimized for memory access cannot be deleted.

ALTER DATABASE A

REMOVE FILEGROUP A_MOD

Filegroup A_MOD is not empty and cannot be removed.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,096 Reputation points
    2020-06-30T04:21:56.187+00:00

    Good day,

    This question is regarding SQL Server which not supported in the QnA forums system yet.

    You selected to use the tag "azure-sql-database", which clearly do not fit your case, since Azure Database service control the files for us

    I recommend to close this thread and move (re-ask) your question in the following forum:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlgetstarted

    0 comments