Database Mirroring

  • db4breakfast

    Ten Centuries

    Points: 1097

    Well, I just joined SSC, and answered first question correct. It's a basic question, but I notice only about 57% people got this right. So, it's not easy for some people. Thanks for the question.

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

  • Abi Chapagai

    SSCrazy

    Points: 2666

    Gail,

    Easy and straight forward question.

    Thanks,

  • Gail Shaw

    SSC Guru

    Points: 1004474

    SQLRNNR (6/24/2011)


    I don't get it? Are you sure about that?

    What are you not sure about?

    I didn't pick the points, I think I'd have made this 1 point and it's partner question (which I think is scheduled for next week) worth 2.

    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
  • Gail Shaw

    SSC Guru

    Points: 1004474

    tnk7200 (6/24/2011)


    Well, I just joined SSC, and answered first question correct. It's a basic question, but I notice only about 57% people got this right. So, it's not easy for some people. Thanks for the question.

    Probably because they're getting mirroring mixed up with log shipping. Log shipping works in full and bulk-logged, database mirroring only works in full recovery.

    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
  • SQLRNNR

    SSC Guru

    Points: 281243

    GilaMonster (6/24/2011)


    SQLRNNR (6/24/2011)


    I don't get it? Are you sure about that?

    What are you not sure about?

    I didn't pick the points, I think I'd have made this 1 point and it's partner question (which I think is scheduled for next week) worth 2.

    Bait worked. all sarcasm

    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

  • Gail Shaw

    SSC Guru

    Points: 1004474

    😛

    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
  • Dhruvesh Shah

    SSCrazy

    Points: 2303

    Knew about database mirroring.

    Didn't know that log recovery works with both modes. thanks.

  • This was removed by the editor as SPAM

  • Peter Trast

    SSCarpal Tunnel

    Points: 4332

    Thanks for the easy question. 🙂

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • Trey Staker

    SSCarpal Tunnel

    Points: 4736

    Thanks for the non-trick question. I've noticed the past month or so that there haven't been the usual "Trick" questions.

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

Viewing 10 posts - 16 through 25 (of 25 total)

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