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