How to merge two partitions with the same name but two seperate ranges

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  December 27, 2021 at 8:42 pm

  #3967598

  I created a new parttion then executed an ALTER PARTITION SCHEME for it to be the next used and then executed ALTER PARTITION FUNCTION to set the date for spliting the range (2022-12-31). The range was incorrect so I executed the ALTER PARTITION FUNCTION to correct the range (2023-01-01) but wound up with two partions numbers. How do I merg or drop the one with thewrong range?

  PartitionNumber            FileGroupName                        TotalRows                 LowerBoundaryValue

  23                                       DB_DPARTITIONS_2023       331                                 2023-01-01

  22                                       DB_DPARTITIONS_2023        28                                  2022-12-31

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  December 28, 2021 at 9:10 pm

  #3967958

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.