- What's New for Installation with SQL Server 2008?
- Preplanning and Preparing a SQL Server 2008 Server Database Engine Installation
- Gathering Additional Information Necessary to Proceed
- Installing a Clean Version of SQL Server 2008
- Upgrading the Database Engine to SQL Server 2008
- Finalizing the SQL Server 2008 Installation or Upgrade
- Managing SQL Server 2008 Installations
- Summary
- Best Practices
Managing SQL Server 2008 Installations
The following sections explain how to manage SQL Server 2008 installations.
Employing Additional SQL Server 2008 Instances
As mentioned earlier, many organizations decide on scaling up their SQL Server infrastructure by creating consolidated SQL Server systems with multiple-instance installations. To achieve the goal of installing additional instances on an existing system, a DBA must relaunch the SQL Server 2008 installation utility, and then select the option New SQL Server Stand-alone Installation or Add Features to an Existing Installation.
When the new SQL Server installation wizard begins, follow the steps in the earlier section “Installing a Clean Version of SQL Server 2008”; however, on the Installation Type page, select the option Perform a New Installation of SQL Server 2008, as displayed in Figure 1.11. Then on the Feature Selection page, select the desired features to be installed for the new instance. Finally, on the Instance Configuration page, provide the instance with a unique name and proceed with the installation.
Figure 1.11 Adding additional SQL Server instances to an existing installation.
Adding Features to an Existing SQL Server 2008 Installation
The process for adding and removing SQL Server features to an existing Installation is similar to the steps involved when adding additional SQL Server instances. The DBA must select New SQL Server Stand-alone Installation or Add Features to an Existing Installation from the SQL Server 2008 Installation Center’s Installation page. However, on the Installation Type screen, the option Add Features to an Existing Instance of SQL Server 2008 must be selected. Then on the Feature Selection page, select the features to be added and continue through the wizard.
Changing SQL Server 2008 Editions
Another feature included with SQL Server 2008 is the potential to conduct an Edition upgrade after SQL Server 2008 has been installed. For example, if an organization is running the Standard Edition and decides that they want to leverage the features and functionality associated with the Enterprise Edition, they simply conduct an edition upgrade instead of formatting and reinstalling from scratch. Another advantageous scenario includes moving from SQL Server 2005 Standard to SQL Server 2008 Enterprise Edition. This objective would be achieved by first upgrading the SQL Server system from SQL Server 2005 Standard to SQL Server 2008 Standard, and then running the Edition Upgrade to upgrade the installation Enterprise Edition of SQL Server 2008.
To conduct an Edition Upgrade on SQL Server 2008, the Edition Upgrade must be selected from the Maintenance page on the SQL Server 2008 Installation Center landing screen.