Mirrors

  • honza.mf

    SSCertifiable

    Points: 5519

    Comments posted to this topic are about the item Mirrors



    See, understand, learn, try, use efficient
    © Dr.Plch

  • This was removed by the editor as SPAM

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts the mirroring session).

    Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)

    (points 4 and 5)

    Are you sure a log backup is needed? Quoting from BOL:

    Typically, you need to take at least one log backup on the principal database. However, a log backup might be unnecessary, if the database has just been created and no log backup has been taken yet, or if the recovery model has just been changed from SIMPLE to FULL.

    Prepare a Mirror Database for Mirroring

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

  • honza.mf

    SSCertifiable

    Points: 5519

    Koen Verbeeck (12/11/2012)


    Are you sure a log backup is needed? Quoting from BOL:

    Typically, you need to take at least one log backup on the principal database. However, a log backup might be unnecessary, if the database has just been created and no log backup has been taken yet, or if the recovery model has just been changed from SIMPLE to FULL.

    Prepare a Mirror Database for Mirroring

    I'm quite sure. The procedure in the question is the same I used to establish the mirror, I tried both wizard and T-SQL. The database was just changed from simple to full recovery model.

    I repeated the test when writing the QotD, with the same result. There was only one difference: First time the error message was completely confusing, but this was not reproduced.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • DugyC

    Hall of Fame

    Points: 3804

    Koen Verbeeck (12/11/2012)


    I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts the mirroring session).

    Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)

    (points 4 and 5)

    Prepare a Mirror Database for Mirroring

    Likewise, however I got this wrong, because rather than thinking it would error, I thought it would succeed but not start the mirroring... learned some useful stuff though, so all good.

    Thanks for the question.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • TomThomson

    SSC Guru

    Points: 104772

    Interesting question.

    I picked the same wrong answer (set up but not started) as 45% of those who answered before me, so I've learnt something.

    Tom

  • Dana Medley

    SSCertifiable

    Points: 6764

    Great question. I picked wrong like a few before me (Set up but not started), so thank you for teaching me something today.



    Everything is awesome!

  • Bob JH Cullen

    SSCrazy

    Points: 2082

    I got it right but, apparently, for the wrong reason. I looked at ALTER Db SET PARTNER = .... and thought that was illegal syntax.

    If it isn't, what is it actually doing, please?

  • PChiragS

    SSCarpal Tunnel

    Points: 4965

    Great QoTD...

    got it wrong, but your explanation was nice..

    learned something...

    thanks...

  • Lokesh Vij

    SSChampion

    Points: 10836

    Same here...also got the question wrong. Thought it would set-up but not start.

    Always good to learn something new 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • SQLRNNR

    SSC Guru

    Points: 281205

    Thanks for the question.

    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

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Good question. Too hard for me.

  • vinayverma1896

    SSC Rookie

    Points: 42

    🙂 Is not getting right answer and lot of work data layer site so can give me suggestion??

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    Why error? what is wrong? Everything seems correct except the mirroring will not start because you miss the transaction log backup restored on the srv2.

    Igor Micev,
    My blog: www.igormicev.com

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

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