Database Mirroring & Service Pack 2 installation

  • Has anybody out there installed SQL 2005 Service Pack 2 on servers running Database Mirroring? I have a need to do so and was wondering about the process; pause mirroring then upgrade both principal & mirror servers? Or failover then upgrade the original principal server, failback & upgrade the original mirror server? Or break mirroring entirely, upgrade both then re-create mirror (ick, nasty)? Or just upgrade the principal then upgrade the mirror, no failover, just let it disconnect for a while (ick ick)?

    Comments appreciated.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • Cool, thanks. I always have trouble finding stuff on the MS site. End up clicking my mouse to death.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


Viewing 3 posts - 1 through 2 (of 2 total)

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