Sql server 2012 Upgrade Technical Guide Writers

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 

---