Removing a filegroup from partition scheme

  • Is there a way to remove a filegroup from partition scheme?

    Or is there another way to do a rolling 6 months partition? My plan is to add new filegroup for new month and drop the oldest filegroup.

  • Nevermind, I realized when I merge the partition. SQL Server will drop the filegroup from the partition scheme automatically.

Viewing 2 posts - 1 through 1 (of 1 total)

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