Sql server 2008 Partition Master and Child tables monthly require downtime to add a new partition every month and delete old partition (Network Steve Forum)

Sql server 2008 Partition Master and Child tables monthly require downtime to add a new partition every month and delete old partition

Hi Team,

Please help me in this regard!!

I have a master and child tables with Foreign key relation, I want to table partition both Master and Child tables monthly basic.

Question 1: To add a new partition every month, downtime is required? Disable foreign key relation and do SPLIT?

Question 2: If Master table is portioned every month and Child is referencing Master table, on every month SPLIT, downtime is required? Can a non-partitioned child table refer partitioned master table?

Thanks,

Areef

February 11th, 2014 1:07am

Hi Guys,

Any update on this?

Areef

Free Windows Admin Tool Kit Click here and download it now

February 11th, 2014 6:04am

This topic is archived. No further replies will be accepted.