Post reply

AlwaysOn and Database Mirroring

  • December 12, 2013 at 10:28 pm

    #74761

    Comments posted to this topic are about the item AlwaysOn and Database Mirroring

  • December 12, 2013 at 10:29 pm

    #1673156

    Great question - thanks Steve

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • December 13, 2013 at 1:46 am

    This was removed by the editor as SPAM

  • December 13, 2013 at 5:46 am

    #1673213

    Steve, nice question. Took about a second to answer it because I set this environment up in development instances and will be promoting to production. I love clustered mirrors. 😀

  • December 13, 2013 at 5:46 am

    #1673214

    That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • December 13, 2013 at 6:29 am

    #1673231

    Ed Wagner (12/13/2013)

    That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.

    Yes, it is true. "Database mirroring" will be a thing of the past for SQL Server 2012 and greater and AlwaysOn group is the preferred method. Cross database transactions can be of issue as well, even with an AlwaysOn, because they are not supported but there are always workarounds. I have had to do this in RAID (mirrored servers) Clustered environments for years.

    Architecting the solution is always "fun." 😎

  • December 13, 2013 at 12:27 pm

    #1673378

    Nice question Steve. Thanks.

  • December 15, 2013 at 11:39 pm

    #1673575

    Ed Wagner (12/13/2013)

    That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the favored flavor.

    +1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • December 16, 2013 at 12:08 am

    #1673578

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 16, 2013 at 12:15 am

    #1673579

    A good question ,learned something.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • December 16, 2013 at 9:49 am

    #1673777

    This one forced me to do some BOL digging over the weekend... Thanks, Steve!

  • December 19, 2013 at 2:11 pm

    #1674999

    Interesting question.

    I took a guess that a new endpoint would be needed on that "another server" so got it wrong. I need to learn more about this stuff.

    Tom

  • December 19, 2013 at 11:42 pm

    #1675054

    Very good question. Thanks Steve. 🙂

  • January 3, 2014 at 1:12 am

    #1677134

    good question

    half balanced for the answers

Viewing 14 posts - 1 through 13 (of 13 total)

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