February 13, 2006 at 6:01 am
Hi,
I'm a newbie. Sorry if this has been discussed anywhere before.
I'm in a situation where I'm consolidating lots of SQL server databases on to a new SQL server 2005 cluster. I have one database that will only run on SQL Server 2000 (third party co. won't support it on 2005) and I would like to have this running on my clustered database servers.
If I setup a 2 server cluster using SS2005 Standard (we only need 2 servers) is there a way of also installing an instance of 2000? The 2000 install doesn't have to be clustered (ideally it would be great however). I'm just wondering how a 2000 instance would work with 2005 clustered?
Anyone have any experience doing this?
I would just install 2000 and use that but I have to pay a huge amount to get the enterprise edition for cluster support in 2000 while 2005 standard will support a two machine cluster.
I hope this makes sense,
Thanks,
Jason.
February 14, 2006 at 6:31 pm
I don't how releveant this is but I have SQL 2000 and the default instance on my PC and SQL 2005 as a named instance ("SQL2005" funnily enough) and both seem to be happy to coexist. I am sure that many people are doing this at the moment as they begin to explore SQL 2005 while still working on SQL 2000 projects.
I don't konw how clustering would behave under these circumstances.
February 15, 2006 at 5:30 am
No, you can't do this.
If you understand first that the OS must be clustered, *then* you install SQL Server, the answer is self evident.
You will need two machines clustered for your 2005 cluster, and a seperate machine for your 2000 instance.
Be careful with the word 'server' when talking about clusters. You might mean the hardware, the OS or the virtual SQL instance.
March 12, 2006 at 4:32 pm
RE: Upgrading active/passive SQL 2000 cluster to SQL 2005:
I'd like to hear more input/experiences with this type of upgrade. We wanted to upgrade SQL 2k Enterprise on our cluster by first doing a side by side install of sql 2005 Enterprise. We use a Dell powervault storage device for our main live database files with system databases residing on a SAN.
If we now have the G drive on the SAN as a cluster resource for the system databases, can we create a subfolder their and do the sql 2005 install on the same two sql boxes using the SAN G drive subfolder for the new system databases?
Or do we have to buy a new SAN and two new sql servers, basically creating a whole new cluster? Last resort, since we aren't likely to make that purchase, is to just upgrade the sql 2k cluster directly to sql 2005. I presume with backups we can always uninstall 2005 and reinstall 2000 if all else fails.
Randy
March 14, 2006 at 3:03 am
How sure are you about this? I think it is not a problem first to Install SQL Server 2000 and later on SQL Server 2005 as a named instance on the cluster.
Do you have a source for your information?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply