• Hard to say... I am assuming this is a Production environment, correct? If so, why not try this in a Dev environment first? Why not run through this a couple times before doing it in prod? Not only to make sure it works as expected and you have a plan for validating your data, but to get an idea of how long each step takes.

    For example, what kind of replication? You or a co-worker have solid replication experience? Setting a replication is a non trivial task. We talking snapshot, transactional? Either way you want to see how long the initial snapshot takes for a 2TB DB.

    How is the data partitioned? And 2TB of what? Data, transaction log? This is not the kind of thing a forum can help you with a few paragraphs of discussion.

    I would say, try it first in a device environment and report back with any concerns.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001