We are planning to migrate to 100 TB of data from one of our client to new SQL Server environment. We just started receiving information from client. It will take couple of months to complete the project. But, can anyone please provide detail plan for migration such a large number of SQL Servers and data. New environment will have 4 fail-over cluster node at 4 different location.

  • Current environment: SQL Server 2008 R2
  • New environment : SQL Server 2014/16

closed as too broad by Shanky, Kin, Philᵀᴹ, LowlyDBA, Marian Oct 22 '18 at 15:34

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 14
    I'm concerned that you are asking such a basic question with such a large project. Haven't you done this before? Is it the scale that's making you worried? Break it down into smaller steps and go from there. – Jonathan Fite Oct 22 '18 at 14:56

The most important part of your question is:

can anyone please provide detail plan for migration

And I've got great news: Microsoft used to build a really detailed Upgrade Technical Guide (429-page PDF) that covered all kinds of details. They haven't updated it since 2014, but the information in there is still really useful for folks who are just starting from scratch and looking for guidance.

The bad news: SQL Server has only gotten more complicated since then. The 429-page length should help explain why it doesn't get updated frequently - it's expensive to build.

Not the answer you're looking for? Browse other questions tagged or ask your own question.