I have a Windows 2008R2 2 node cluster with SQL Server 2008 clustered. How do I prevent the cluster from failing over while I am applying the SQL Server 2012 to the alternate node first? Any pointers on upgrading the SQL Server cluster to 2012?
migrated from stackoverflow.com Oct 8 '13 at 14:00
This question came from our site for professional and enthusiast programmers.
You can do rolling upgrade and use
Refer to :
You could use the GUI (failover cluster admin) or PowerShell to accomplish this task. Below is an example of the latter:
All of the parameter strings there need to be specific to your environment. Note, calling
Something to be knowledgeable about, there is a KB for a fix for a failover cluster instance upgrade from SQL Server 2008 [R2] to SQL Server 2012. I recommend you review it before the operation.
As for other tips and tricks, I would recommend you read this BOL reference on upgrading a SQL Server Failover Cluster Instance. There is a lot of great information in that article that should be considered.