Adding SQL Server 2014 node to SQL Server 2008 R2 cluster

  • Hi,

    We have 2-node SQL Server 2008 R2 Cluster. I'm going to add a new node with SQL Server 2014 and then, after some time, upgrade the cluster to SQL Server 2014. Does the scenario look real?

    Cheers,

    Andrei.

  • Bad things are going to happen if you try to fail from 2014 to 2008R2. If you failover to the 2014, you're stuck there until you upgrade the 2008R2 instance, so it's a risk

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • GraveD (11/14/2014)


    Does the scenario look real?

    If by 'some time' you mean 'a few minutes', then yes. Otherwise no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Understood. Thank you very much for your response.

  • You're very welcome, glad you found it useful, and thank you for the feedback

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • GraveD (11/14/2014)


    Hi,

    We have 2-node SQL Server 2008 R2 Cluster. I'm going to add a new node with SQL Server 2014 and then, after some time, upgrade the cluster to SQL Server 2014. Does the scenario look real?

    Cheers,

    Andrei.

    lets break this down

    2 node cluster using which OS?

    which OS on the node you intend to add?

    are the existing instances clustered on the 2 node cluster?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply