cumulative update on sql server with mirroring

Question

Hi

I need advice, please help. this month microsoft is having security update for SQL Server 2012 SP4 CU(KB4583465)
My sql is running on High safety without automatic failover, so i have follow the recommended prepararation (best Practices)

1. Perform a practice manual failover on the only mirroring database
2. Perform a full database backup and run the DBCC CheckDB(no error & etc).

i am stuck with stage of a rolling upgrade.

It mention to

1. upgrade the mirror server (i think it means the server that runs the database with mirror/synchronise and restoring) right?
2. manually fail over to upgraded mirror server (does this mean failover the principal to this mirroring server after the updates?)
3. Run DBCC CheckDB (OK i understand).
4. Resume miroring (Does this mean it miss the steps to pause the miror before steps 1?)

Answer 1

upgrade the mirror server (i think it means the server that runs the database with mirror/synchronise and restoring) right?

Yes correct. This means the server which holds the mirror database which is in recovery.

manually fail over to upgraded mirror server (does this mean failover the principal to this mirroring server after the updates?)

Yes correct, post upgrade of mirror server, you would also have to update principal but to do that you have to make it mirror. Hence you need to failover to mirror also this is part of upgrade.

Resume miroring (Does this mean it miss the steps to pause the miror before steps 1?)

Yes, as a best practice, pausing the mirroring is advisable.