HA / DR

May 082015 Tagged with , 0 Responses

SQL Server Cluster P2P migration

Motto: “it should be out there”

Recently, my team was involved in several SQL Failover Cluster Instances migration. All nodes were physical boxes and migration was done between two Data Centers.

Due to business constraints, we had no option but to rebuild the clusters in the new Data Center, keeping everything as before and with as minimum downtime as possible.

Migration should be transparent to all applications/users that connect to the instances.

Nice challenge, we said.

Single instance migration was documented and you may find it at:

http://yrushka.com/index.php/database-recovery/sql-server-migration-from-one-server-to-another-detailed-checklist/

How about cluster migration? The steps we took to ensure all migrations were successfully are listed below.

I know.. most of the steps are only backups/information and may be skipped. A backup may never suffice. When downtime is important, any piece of backup/information is valuable.

Always do a test before, check whatever steps apply to your environment, add others, document the procedure and go live. Read More…