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

  • Question


    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?



    • Moved by Papy Normand Tuesday, February 11, 2014 9:16 PM Moved from the SQL Server Data Access Forum : I have merged another thread from the OP in this new forum.
    Tuesday, February 11, 2014 6:05 AM

All replies