Database Mirroring Restrictions

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Comments posted to this topic are about the item Database Mirroring Restrictions

  • Koen Verbeeck

    SSC Guru

    Points: 258909

    Meh, who cares about mirroring 😀 Availability Groups FTW!

    Thanks for the question.

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

  • This was removed by the editor as SPAM

  • Luis Cazares

    SSC Guru

    Points: 183532

    I hope that the wording for the answers could be corrected as there might have been translating issues or something (even if one could understand the intentions).

    Thank you for the question. 🙂

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Xavon

    SSCrazy

    Points: 2280

    The answers should have been a little more varied; as soon as one recognizes that restrictions 1 and 2 are both true, then 3-5 do not matter because 'all true' is the only possible answer.

  • SQLRNNR

    SSC Guru

    Points: 281210

    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring 😀 Availability Groups FTW!

    Thanks for the question.

    AG, AG on the wall, who is the fairest of them all?

    Nah - that just doesn't have the right ring to it. We better keep the mirrored databases a little longer. :hehe:

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQL_Hunt

    SSC-Dedicated

    Points: 33261

    Nice easy question. Though hardly database mirror is in use, but good to recall the past.

    Thanks.

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Thanks.

  • Jacob Wilkins

    One Orange Chip

    Points: 27727

    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring 😀 Availability Groups FTW!

    Thanks for the question.

    Heh, I really hope mirroring doesn't go away for a long, long time. AGs, for all their benefits, still can't be reasonably used to do all the things mirroring could do. It'll be a sad day when Microsoft actually takes it away.

    I'm assuming all the answers were supposed to read "Only restrictions 1, 3, and 5 are true" and so on, but once I got over my initial confusion about the placement of the first number in each answer, that seemed clear enough.

    Cheers!

  • Ken Wymore

    SSCoach

    Points: 16358

    Xavon (7/15/2015)


    The answers should have been a little more varied; as soon as one recognizes that restrictions 1 and 2 are both true, then 3-5 do not matter because 'all true' is the only possible answer.

    Agreed, easy process of elimination.

  • yaboo baboo

    Newbie

    Points: 4

    Only 1 restrictions, 3 and 5 are true seems a very strange option.

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6376

    Ok.

  • Ed Wagner

    SSC Guru

    Points: 286957

    Hugo Kornelis (7/16/2015)


    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?

    That would be me. Not today, and tomorrow isn't looking good either.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

Viewing 15 posts - 1 through 15 (of 18 total)

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