We are planning on migrating our existing SQL 2012 servers from current windows servers to new windows servers. Only difference is we are migrating this current instance which is standalone to Clustered SQL instance. [New windows server has been built and SQL is configured as clustered instance]

Therefore we need to migrate on the same SQL2012 and windows 2012 version. Total database sizes on the instances are over 20 TB. And yes this is 24*7.

What all measures should i take or please suggest any action plan for this migration that can help me to kick start the migration process in above scenario?

  • Would it be possible to use the existing server as a node in the cluster and AG? If yes, once data is in sync, fail over to another node, then remove the existing server from the cluster. – Tony Hinkle Jan 11 '18 at 16:09

What sort of downtime do you have available for the migration?

There are a couple of ways that I'd approach this, as you're 24\7 and need to migrate 20TB of data, I'd be wanting to stage it beforehand. You could either do this with logshipping, setup logshipping to your new server ahead of time and then when it comes to the cutover, take a final log backup, play it into the new server and bring online.

Another option and the one that I tend to use when migrating large databases is to mirror over to the new server. When it comes to cutover, it's a simple job of just failing the mirror over and then then stop mirroring. There are a few advantages of that approach, it can be setup days ahead of time, cutover is quick with no risk of data loss and it also preserves the log chain.

I wrote about using mirroring in a migration situation here, https://sqlundercover.com/2017/01/21/sql-mirroring-preserving-the-log-chain-during-database-migrations/

Just make sure that any logins you script across from the old server includes the SID, otherwise you could end up with a ton of orphaned users. Not the end of the world but a hassle you don't need on migration day.

  • ooh, i've bookmarked that blog post – James Jan 11 '18 at 19:23

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