Condividi tramite

Can I Migrate SQL 2012 AlwaysOn availability groups on a windows 2008 R2 cluster to Windows 2012 cluster?

  • Articolo

The Answer is yes. You will need SQL 2012 SP1 to do this. SQL2012 SP1 was announced at the SQL Pass conference last week (Nov 7th).

How: The SQL Server product team will be publishing the steps in the "Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade" white paper. This paper was to be posted in October 2012 on the Microsoft White Papers (SQL Server 2012) download page. However it’s not available yet. So watch the Whitepaper downloads page for updates.

More details on the SP1 Feature can be found here:

Cross-Cluster Migration of AlwaysOn Availability Groups for OS Upgrade

SQL Server 2012 SP1 introduces support for cross-cluster migration of AlwaysOn Availability Groups deployments to a new Windows Server Failover Clustering (WSFC) cluster. A cross-cluster migration moves one AlwaysOn availability group or a batch of availability groups to the new, destination WSFC cluster with minimal downtime. The cross-cluster migration process enables you to maintain your service level agreements (SLAs) when upgrading to a Windows Server 2012 cluster.  SQL Server 2012 SP1 must be installed and enabled for AlwaysOn on the destination WSFC cluster.  The success of cross-cluster migration depends on thorough planning and preparation of the destination WSFC cluster.

Comments

  • Anonymous
    December 14, 2014
    The same method works for cross-domain migrations. If you may please include that in the doc.