Clustering SQL Server 2000
-
Environment:
SQL Server 2000 SP3a on W2K Advanced Server SP4.
1 IBM Server x440 with FastT700 Storage (Fibre Channel)
We need to buy another IBM Server x440 or x445 and we would like to make a cluster.
Question 1:
Once we build the Cluster with the installation of the Cluster Service, making the W2K Cluster, is it possible to upgrade the default instance of SQL Server to a default clusterd instance of SQL Server?
In BOL I have found a note that explain how to do this but I have some doubts.
When I installed SQL Server I placed the system files on the C: drive, the DB files on our SAN on disk E: and the log files on disk F:.
Question 2:
If we would like to use Windows Server 2003 what would be the possibility for an upgrade?
I mean, should I erase all and start with Windows Server 2003 setup or can you suggest to upgrade the OS first, from W2K Advanced Server, and then cluster SQL Server if possible?
Can you advice please?
Any help is really appreciated.
Thank you very much for your time.
Franco
Franco -
If it is SQL Server 2000 Enterprise Edition, you should be able to do so.
In BOL, Index Tab: "failover clustering, upgrading clusters." In the pop-up, "How to upgrade from a default instance to a default clustered instance of SQL Server 2000 (Setup)."
K. Brian Kelley
@kbriankelley -
You need consider where is your current SQL binaries. On the cluster, SQL binaries need on the shared cluster drive.
-
"You need consider where is your current SQL binaries. On the cluster, SQL binaries need on the shared cluster drive. "
It is true in SQL Server 7.0 but In SQL Server 2000, SQL Server installation creates executable files in local drive of each nodes.
-
I think you have this the other way around.
The binaries are on the local drives. The data files are on the shared media.K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply