May 15, 2019 at 4:40 pm
I have created a table partition on SQL Server 2017.
We have a rolling window of 30 Month .All the old data beyond rolling window will be deleted using truncate partitions .After that i removed the file but i am not able to remove file group.There is no file attached with that file group .
Following is the error message.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Drop failed for FileGroup 'FG1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17277.0+((SSMS_Rel_17_4).180625-0100)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+FileGroup&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The filegroup 'FG1' cannot be removed because it is not empty. (Microsoft SQL Server, Error: 5042)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.3037&EvtSrc=MSSQLServer&EvtID=5042&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply