6
SQL Server 2012 Upgrade Technical Guide
Conclusion ................................................................................................................................... 124
Additional References ............................................................................................................ 124
Chapter 4: High Availability ............................................................................. 126
Introduction ................................................................................................................................ 126
Preparing to Upgrade ............................................................................................................. 126
In-Place Upgrade.......................................................................................................................................... 126
Side-by-Side Upgrade on the Same Standalone Server or Cluster .......................................... 127
Side-by-Side Upgrade to a Separate Standalone Server or Cluster ......................................... 129
Decommissioning and Disabling the Original Instance or Database in a Side-by-Side
Upgrade ........................................................................................................................................................... 130
Methods for Side-by-Side Upgrades to a Separate Server or Cluster ..................................... 130
Which SQL Server Upgrade Method Should You Use? ................................................................. 133
Minimizing Downtime During the Upgrade ................................................................. 133
Prepare for SQL Server 2012 .................................................................................................................... 133
Devise an Upgrade Plan ............................................................................................................................ 135
Test the Upgrade Plan ................................................................................................................................ 137
Prepare Servers and Instances for SQL Server 2012 ....................................................................... 138
Upgrading Failover Cluster Instances .............................................................................. 142
Feature Changes in SQL Server 2012 Failover Clustering ............................................................. 142
Operating System Versions and SQL Server 2012 Failover Clustering .................................... 143
Considerations for Upgrading a SQL Server 2005 Failover Cluster to SQL Server 2012 ... 147
Considerations for Upgrading SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2012
............................................................................................................................................................................. 149
Considerations for Upgrading a Pre-Release Version of SQL Server 2012 to RTM ............ 149
Upgrading a Failover Clustering Instance to SQL Server 2012 ................................................... 150
Additional References for Clustering Upgrades ............................................................................... 171
Upgrading Mirrored Databases ......................................................................................... 171
Feature Changes in SQL Server 2008 R2 Database Mirroring ..................................................... 171
In-Place Upgrade.......................................................................................................................................... 172
Side-by-Side Upgrade to a New Server .............................................................................................. 175
Additional References for Upgrading with Mirrored Databases ................................................ 177
7
SQL Server 2012 Upgrade Technical Guide
Upgrading Log Shipped Databases .................................................................................. 177
Feature Changes in SQL Server 2012 Log Shipping ....................................................................... 177
Log Shipping Upgrade Scenarios........................................................................................................... 177
Upgrading with Multiple Secondaries .................................................................................................. 178
Steps to Upgrade Log Shipping without a Role Change .............................................................. 178
Steps to Upgrade Log Shipping with a Role Change ..................................................................... 181
Steps to Upgrade Side-by-Side to a New Server or Cluster ........................................................ 184
Additional References for Upgrading Log Shipping ....................................................................... 186
Upgrading Replicated Databases ...................................................................................... 186
Feature Changes in SQL Server 2012 Replication ............................................................................ 186
Planning an Upgrade with Replication ................................................................................................ 186
In-Place Upgrade.......................................................................................................................................... 188
Side-by-Side Upgrade to a New Server or Cluster .......................................................................... 192
Additional Information for Upgrading Replicated Databases .................................................... 194
Conclusion ................................................................................................................................... 194
Additional References ............................................................................................................ 195
Chapter 5: Database Security ........................................................................... 196
Introduction ................................................................................................................................ 196
New Security Features ............................................................................................................ 196
New Configuration Tools .......................................................................................................................... 197
Configuring Services and Connections ................................................................................................ 198
Service Account Security ........................................................................................................................... 199
Configuring Features .................................................................................................................................. 200
SQL Server Audit .......................................................................................................................................... 201
Preparing to Upgrade ............................................................................................................. 202
Deprecated Features ................................................................................................................................... 202
Discontinued Features ................................................................................................................................ 204
Breaking Changes ........................................................................................................................................ 205
Behavior Changes ........................................................................................................................................ 205
Pre-Upgrade Security Tasks ..................................................................................................................... 206