Database Reference
In-Depth Information
The windows architecture upgrade is also essential such as an upgrade from a 32-bit to a
64-bit platform. Additionally, the upgrade from a Standalone server to Microsoft Clustering
services is required:
F
Upgrading from SQL Server 2005: Run the upgrade from the command prompt on
each failover cluster node, or by using the Setup UI to upgrade each cluster node. If
Full-text search and Replication features do not exist on the instance being upgraded,
then they will be installed automatically with no option to omit them.
F
Upgrading from SQL Server 2000: This is similar to upgrading from SQL Server
2005. You can run the upgrade from the command prompt on each failover cluster
node, or by using the Setup UI to upgrade each cluster node. It's supported for
32-bit scenarios only. Failover cluster upgrades from SQL Server 2000 (64-bit) are
not supported.
Before you install SQL Server 2008 R2, we should also run the SQL Server Best Practices
Analyzer (BPA) against your current legacy instances of SQL Server. If bad or questionable
practices exist, you can then address them before the upgrade, moving the fixes through test
and into production. The BPA tool installation is a straight-forward process and this diagnostic
tool performs the following functions:
F
Gathers information about a server and installed SQL Server instances
F
Determines if the configurations are set in accordance with the best recommended
practices
F
Produces a report on all configurations that indicates settings that differ from
recommendations
F
The report consists of any potential problems in the installed instance of SQL Server
and recommends solutions to potential problems
No configuration settings or data is changed when you execute this tool.
How to do it...
The following steps are classified as the best practices approach in preparing the environment
for an upgrade:
1.
To obtain the relevant Best Practices Analyzer (BPA) tool that suits your legacy
instances of SQL Server, refer to the following links:
44ee-893e-9e07339c1f22&di
splaylang=en
.
4991-82FA
-F0E3FBD05E63
.
Search WWH ::
Custom Search