• great, thats the plan to do next for the partition.. quick question though since we have minimum down time and if we like create db with partition in multiple file group based on year/month, can we replicate the data with that newily created partition table to minimize the cut over period having said one production and another mirror to the database which has the partition on it. sorry for too many questions.. this things are giving so much hard time.

    Thanks

    Sagar