Rolling Upgrade to SQL Server 2008 R2

 

Step:

  1. Install the Service Pack on the Mirror
  2. Failover to the upgraded Mirror
  3. Install the Service Pack on the Principal
  4. Failover to the upgraded Principal

 

Creative Commons license icon Creative Commons license icon