Re: upgrading sql2k cluster to sql2005

Actually, the recommended method for upgrading clusters is to do so in
place.

You need to run the Upgrade Advisor to ensure that there aren't any issues
with the databases. Then when you upgrade it in place, it will handle
upgrade of all of your logins, linked servers, configuration, and everything
else at an instance level as well as with each database. The SQL Server
will also only be offline for a very brief 1 - 2 minutes during the inplace
upgrade.

While a side-by-side upgrade can be done, it has the potential to cause LOTS
of issues. The first one that you will run into is that you will need to
add new disk resources into the cluster for the 2005 installation since you
can not use the same disk drives for more than one SQL Server instance. If
you don't have spare disk resources to add into the cluster, you can't do a
side-by-side upgrade.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.


"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OKCVmsSbGHA.144@xxxxxxxxxxxxxxxxxxxxxxx
The safest method would be to install a separate virtual instance of SQL
Server 2005 and migrate DB's to it. You can test it out a lot before you
do
the formal cutover. Once you've cut over, then deinstall SQL 2000 and
reclaim its disk resources.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Gregg" <Gregg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9478CA3-2037-46B4-90E6-440500770E93@xxxxxxxxxxxxxxxx
Hi,

We are running portal server front end (3 servers) and sql2k clustered
(active/passive) as the back end. We would like to upgrade to sql2005.
Any
suggestions on the best method?

thanks,
Gregg



.

Relevant Pages

  • Re: NT to W2K3 Migration
    ... You cannot just promote a member server to AD. ... upgrade your PDC to windows 2000 or 2003, whichever flavor of AD you want to ... Upgrading from Windows NT Server 4.0 ... ensure that you have designed a DNS ...
    (microsoft.public.windows.server.active_directory)
  • Re: Native 2003 mode and NT4 workstations?
    ... Migrating from Windows NT Server 4.0 to Windows Server 2003 ... How to Upgrade from Windows NT Server 4.0 ... ensure that you have designed a DNS ...
    (microsoft.public.windows.server.active_directory)
  • Re: NT to W2K3 Migration
    ... How to Upgrade from Windows NT Server 4.0 ... Best Practice Active Directory Design for Managing Windows Networks ...
    (microsoft.public.windows.server.active_directory)
  • Re: Migrating NT4 to Windows 2003
    ... Migrating from Windows NT Server 4.0 to Windows Server 2003 ... How to Upgrade from Windows NT Server 4.0 ... Best Practice Active Directory Design for Managing Windows Networks ... ensure that you have designed a DNS ...
    (microsoft.public.windows.server.active_directory)
  • Re: Migrating NT4 to Windows 2003
    ... Migrating from Windows NT Server 4.0 to Windows Server 2003 ... How to Upgrade from Windows NT Server 4.0 ... Best Practice Active Directory Design for Managing Windows Networks ...
    (microsoft.public.windows.server.active_directory)
Loading