cumulative update on sql server with mirroring

Derrick Chan Chee Choon 21 Reputation points
2021-01-28T09:55:37.947+00:00

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?)
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
0 comments No comments
{count} votes

Accepted answer
  1. Shashank Singh 6,246 Reputation points
    2021-01-28T14:39:27.287+00:00

    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.


0 additional answers

Sort by: Most helpful