In Azure SQL Database, dbo.FactOrderHistory uses monthly RANGE LEFT partitions with aligned indexes, and partition 1 contains the oldest month. That month's rows must remain available in dbo.Archive, which does not exist, while its range is retired from the operational table without moving retained rows. Arrange the required actions in order. Not all options are used.
Run ALTER PARTITION FUNCTION with MERGE RANGE at the lowest boundary of the function used by dbo.FactOrderHistory.
Create dbo.Archive on PRIMARY with columns, indexes, and a range constraint compatible with the oldest month of dbo.FactOrderHistory.
Run ALTER PARTITION SCHEME with NEXT USED [PRIMARY] on the partition scheme used by dbo.FactOrderHistory.
Run ALTER TABLE dbo.FactOrderHistory SWITCH PARTITION 1 TO dbo.Archive to reassign the oldest partition's data.
Run UPDATE STATISTICS dbo.FactOrderHistory WITH FULLSCAN to refresh the table's optimizer statistics.