none
What version are we refering too? RRS feed

  • Question

  • I am reading this article about rolling update for always on availability group: https://msdn.microsoft.com/en-us/library/dn178483.aspx

    It basically states that replicas of different version will not be able to perform data movement to earlier versions and secondary replica or lower versions will not be readable.

    Question is, what version are they referring too.  Major version, minor version or the whole version including service packs, cumulative updates and build?

    In other words, do those concerns apply when applying service packs?

    Friday, December 9, 2016 3:36 AM

Answers

  • Exactly Major + Minor; just as an example SQL Server 2008 = 10.0 is not forward compatible to SQL Server 2008 R2 = 10.5

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Antoine F Saturday, December 10, 2016 1:01 PM
    Friday, December 9, 2016 6:35 AM

All replies

  • Only the Major version. This does not include any CU, SP within same version.


    Kindly mark the reply as answer if they help

    Friday, December 9, 2016 5:29 AM
  • Exactly Major + Minor; just as an example SQL Server 2008 = 10.0 is not forward compatible to SQL Server 2008 R2 = 10.5

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Antoine F Saturday, December 10, 2016 1:01 PM
    Friday, December 9, 2016 6:35 AM
  • My thought...

    That said, version = Major version.Minor Version.Service Level (SP+ CU).build.

    Kind of confusing when the documentation refers to version without specifying major, minor, etc.

    Thanks

    Saturday, December 10, 2016 1:06 PM