instances installed on the same system and to upgrade them separately. SQL Server supports up to 50 instances on the same system,
and each named instance is essentially a different installation of the
SQL Server code. As you can see in Figure 9, a default instance named
MSSQLSERVER has been selected to be upgraded. Clicking Next displays the Select Features dialog box shown in Figure 10.
Figure 10
Reviewing the
Installed Features That
Will Be Upgraded
The Select Features dialog box shows you the installed features that
will be upgraded. All of the installed options are checked by default—
you can’t choose to update only some of the features. When performing an upgrade to SQL Server 2012, you must update all of the installed
features in the selected instance at the same time. Clicking Next displays the Instance Configuration screen, which Figure 11 shows.
The upgrade process will detect all the installed SQL Server instances
and list them in the Installed instances box at the bottom of the screen.
www.sqlmag.com
sql server Pro / may 2013
