Post reply

DB mirroring support MSSQL 2014

  • March 3, 2016 at 6:25 am

    #324657

    HI There,

    i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will be deprecated since the release of 2012 but its still there. does anyone have any links or text that specifically says yes it is supported in 2014?

    Thanks in advance,

  • March 3, 2016 at 6:32 am

    #1862718

    Deprecated doesn't mean 'not supported'. It means that it will be removed in a future version.

    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

  • March 3, 2016 at 6:34 am

    #1862719

    nialldunne (3/3/2016)

    HI There,

    i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will be deprecated since the release of 2012 but its still there. does anyone have any links or text that specifically says yes it is supported in 2014?

    Thanks in advance,

    It is. I have used it.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 3, 2016 at 6:45 am

    #1862725

    Good stuff, thanks for the clarification

  • March 3, 2016 at 7:45 am

    #1862754

    I can promise you that I will still have clients using mirroring at least 10 years from now, probably 15.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 3, 2016 at 8:10 am

    #1862771

    TheSQLGuru (3/3/2016)

    I can promise you that I will still have clients using mirroring at least 10 years from now, probably 15.

    Is that because it is a stable feature of much use?

  • March 3, 2016 at 8:36 am

    #1862788

    Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being released in SE on 2016+ IIRC.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 3, 2016 at 8:50 am

    #1862796

    TheSQLGuru (3/3/2016)

    Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being released in SE on 2016+ IIRC.

    Is that anything more than a rumour? Is there a list somewhere of what is in SE 2016?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 3, 2016 at 2:35 pm

    #1862934

    It is confirmed here: https://msdn.microsoft.com/en-us/library/mt614935.aspx

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 3, 2016 at 2:40 pm

    #1862936

    TheSQLGuru (3/3/2016)

    It is confirmed here: https://msdn.microsoft.com/en-us/library/mt614935.aspx

    Making it easier for others:

    https://msdn.microsoft.com/en-us/library/mt614935.aspx

  • March 3, 2016 at 3:56 pm

    #1862955

    Thanks, guys.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 11 posts - 1 through 10 (of 10 total)

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