I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
Yes. This is supported as SQL Server 2005 and 2000 can be installed side by side on a cluster successfully. With regard to achieve this there should be more care on choosing the shared- disks & IP addresses with sensible resourced hardware. 1. Separate Physically-shared disks for SQL Server 2005...