SQL Server Partition

  • Padmarani

    SSC Rookie

    Points: 32

    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



    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





Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply