I have a Production server and DR server where the databases are mirrored, both on SQL Server 2012 SP1. I want to apply SP3. I can do this on a weekend and I don't want a failover.
Should these be the steps:
- Pause data flow from Production to DR.
- Apply SP3 to the DR server.
- Apply SP3 to the Prod server.
- Restart the dataflow