Jeff,

I will definitely be moving this database to new storage and partitioning as part of the move. I would like to use your process, stored procs, etc. Here are some assumptions/questions regarding your steps. Please comment...

1. Along with the DB I will create 22 Files and 22 File Groups for 5 months of weekly partitions. Or does your step #3 do that for me?

2. I am trying to get my mind around the implications of my two tables' RI relationship. I guess each table gets its own partitioning function and scheme? I am not sure exactly how I create the tables with the "null week, first week, next week" etc. Can you help me understand the "how" of that?

3. Do I just use your "090 Transfer The Data" script to do this?

4. ok

5. ok

6. ok

7. ok

8. Will this job just execute a version of your Audit_MonthlyProcess stored proc that I have modified for my environment?