I have a table that will have four months of data that I want to partition. The key will be the number 1 through 4 and then we want to break it down by week in each partition 1 through 5.
What would be the best type of partition for this? We want to make sure we can do an online backup of each partition. Database is 220.127.116.11.