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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Oct 8 '13 at 14:00
This question came from our site for professional and enthusiast programmers.
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.
You can do rolling upgrade and use
Refer to :