Error switch partition

• samirca007

  SSC-Addicted

  Points: 417

  More actions

  January 23, 2020 at 7:42 am

  #3717639

  hello

  Good morning all

  I want to switch the partition from one table to another

  I have this error message on a blocking because of the index

   

  ALTER TABLE sales.SalesOrderDetail
      SWITCH PARTITION 1 TO 
  sales.SalesOrderDetail_2014 PARTITION 1;

   

  Warning: the partition specified 1 for the table 'produit.sales.SalesOrderDetail_2014' was ignored in the ALTER TABLE SWITCH statement, because the table is not partitioned.
  Msg 7733, Level 16, State 4, Line 1
  The 'ALTER TABLE SWITCH' statement failed. table 'produit.Sales.SalesOrderDetail' is partitioned while index 'IX_SalesOrderDetail_ProductID' is not.
  
  End time: 2020-01-23T08: 34: 45.9707743 + 01: 00

   

  

  thanks

• frederico_fonseca

  SSCoach

  Points: 16167

  More actions

  January 23, 2020 at 8:55 am

  #3717651

  error is pretty clear - produit.sales.SalesOrderDetail_2014 is not partitioned - the image you posted is for the table sales.SalesOrderDetail

  if your partitions are yearly and if you archive onto 1 table per year then most likely what you need is

  ALTER TABLE sales.SalesOrderDetail

  SWITCH PARTITION 1 TO

  sales.SalesOrderDetail_2014 -- remove the destination partition