June 22, 2006 at 6:53 am
Hi,
Im trying to switch a partition from partitioned table to a non partitioned table. I am getting the following error.
eCertified.dbo.Carrier_Trip_AvailabilitySwitch.PK_Carrier_Trip_AvailabilitySwitch_1' is in filegroup 'PRIMARY' and partition 24 of index 'eCertified.dbo.Carrier_Trip_Availability_Partition.PK_Carrier_Trip_Availability_Partition' is in filegroup 'SECONDARY24'. [SQLSTATE 42000] (Error 4939). The step failed.
The table one has 24 partitions and it has a partitioned clustered index. PK_Carrier_Trip_AvailabilitySwitch is the primary key in the non partitioned table and its is in the primary file group while the PK_Carrier_Trip_Availability_Partition is the primary key iin the partitioned table and its in the file group secondary 24.
Please let me know how to solve this issue. thanks in advance
with smiles
santhosh
June 22, 2006 at 8:10 am
One basic requirement for partition switching is both the source partition and the target table and their blob columns (text, image etc) must in the same file group.
You need to define your non-partitioned table in the same file group as the switching partition
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply