Installing Sql 2000 along with SQL 2005 1

[19972003]

Anyone has good recommendation of how to install the SQL 2000 server? I have two sql servers, one is sql2k and the other is 2005; My ultimate goal is to have redundancy of the servers; sql 2005 is in test environment at the moment, can I install instance of the SQl 2000 and just let it sit there? If my sql 2000 server failed I can just quickly get the backup copy of the database and attach to SQL 2005 server where the standby sql 2000 instance sits? Or will it better to have the database to store on SAN and just have the instance of the SQL 2000 points the DB to SAN? What would be the most ideal solution in terms of the disaster recovery?

Many thanks,

 

[19972003]

To cluster the SQL 2005 and Sql 2000 Server, I will need to have two servers with win 2003 EE and SQL 2000 EE installed as well the the SAN.

I have the SAN setup in my house already, do you think if I use the current SAN will work with the clustering? I have about 110GB free space on it. All I need is to configure the Raid to three partition.Can you kindly explain how I can setup the sql 2000 cluster? would it be possible to put sql 2000 and sql 2005 on the same server and set it up in the cluster or it is very hard to do? I am trying to not to buy four servers if it is possible.

Here is my thinking:

For SQl 2005 Clustering:
2 PE Servers with Fiber Channel card install
Win 2003 EE and SQL 2005 SD
SAN

For SQL 2000 Clustering:
2 PE servers with FIber channel Card install
Win 2003 EE and SQl 2000 EE
I will just the sql 2005 license for my sql 2000 server, right?
SAN

Also, do you think it makes sense to have Standby server (exact model as the production sql db server)? Or there is some other solutions out there that I can use.

Thank You

 

[mrdenny]

Yes you can use the current SAN as long as it has enough space to meet your servers requirements.

To setup the cluster you first have to get the Windows OSs clustered. You will need a crossover cable between the machines, and then run through the wizzard in the cluster administrator. Then run the SQL install on one of the machines and when at the screen to select if it's a local or remote install the third option will be available. Select that option and walk through the installer.

You can install SQL 2000 and SQL 2005 on the same cluster. It will work fine.

With a cluster there is no need for a standby server. The cluster provides the standby server as it has an active node and a passive node.

You may want to look to bringing in a consultant to set this up if you are new to clustering.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19972003]

Thanks again, can you tell me if the following specs will meet the clustering?

2xPE 1950/8GB Ram and 146GB 15RPM drive
Connect the FC to the Existing SAN(do I configure the SAN first or install the Clustering server first or it doesn't really matter?

what is active mode and a passive mode? did you mean that I can install the SQL 2000 and SQL 2005 on the same exact server and configure as the cluster solution? so that I will not need to purchase have four physical servers? How is license come in play if I put sql 2000 and 2005 on the same server? I just need to have Windows EE OS (license) and license for sql 2000 and sql 2005 on one of the cluster server and the other cluster server I will just need the OS license? I would like to set it up myself so that I can learn the tech and know how to do it.

Thanks again

 

[mrdenny]

Those machines will be fine. Clustering doesn't have any hardware requirements really. As long as the machine will support SQL Server you should be fine.

Clusters have two or more nodes. In your case you have have two nodes. Nodes are simply the physical servers.

There are two types of clusters active/active and active/passive.

In active/active there are two or more SQL Instances running on the cluster with one or more instances on each node. In active/passive there are one or more insances running on the cluster with all instances on a single node where the second node is sitting there passive as a backup.

The licensing for a cluster can get tricky. The basics are:
If you are using an Active/Active cluster you need one Windows licenses for each node.
If you are using an Active/Passive cluster are you have software assurance you only need one Windows license.
If you are using an Active/Passive cluster and you do not have software assurance you will need one Windows license for each node.

For the SQL licensing:
If you are running an Active/Passive cluster and you have a SQL 2005 license you do not need a SQL 2000 license. You can install the second instance under your downgrade rights.

If you are running an Active/Active cluster you will need to have the correct licenses to cover the services on each node. In your case with two intances, if you ran Active/Active you would need either two SQL 2005 licenses (using the downgrade rights which come with them to install SQL 2000 for one instance) and the second license for the SQL 2005 instance.

Here is an FAQ on SQL Server licensing faq962-5153.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19972003]

For the SQL licensing:
If you are running an Active/Passive cluster and you have a SQL 2005 license you do not need a SQL 2000 license. You can install the second instance under your downgrade rights.

Do you mean that I can install sql 2005 as well as the sql 2000 EE edition on First node and I Just need the license Active/Passive Mode:

SQL Clustering:

ServerA: win 2003 EE (OS Licenses), SQL 2005 SE (SQL Licenses Needed), SQL 2000 EE (don’t need, will use downgrade rights)


ServerB: win 2003 EE (OS License) SQL 2005 SE (do I need Licenses here), SQL 2000 EE Do I need Lisencse here)

1xSAN with Qurom configured and Data drive, log drive configure.

One cluster can consites two version of SQL server install on it?

 

[mrdenny]

To install SQL 2000 EE under the down grade rights you would have to purchase SQL 2005 EE. You can not downgrade from Standard Edition SQL 2005 to Enterprise Edition SQL 2000.

Correct, if both instances are on the same machine, Microsoft's licensing allows both instances to run on a single license just like if you install two instances on a single server. It's mentioned in the FAQ, as well as on the Microsoft site. I would recommend reading both to ensure that you are correctly licensed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19972003]

if I don't have Active Directory in place, there is no way I can implement the Sql cluster; is this correct or there is another alternative out there?

 

[mrdenny]

Correct, Active Directory is required to Cluster Windows using the Windows Cluster Service. There are other third party tools available for various kinds of fail over, most of them probably require Active Directory as well.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19972003]

Is there a way to cluster the SQL 2005 in workgroup by use win 2003 server and Sql SE? Also, is there a good whitepaper out there can show you how to configure the sql 2000 along with SQL 2005 on the Same clutering?

Thanks again,

 

[mrdenny]

No there is no way to setup a cluster in a workgroup. A domain is required.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19972003]

Thanks again, I will let you know once I get the project going?

 

[19972003]

Hi, it turns out that our SAN is not a real SAN setup, it is RAID Array. are you familiar with X-SAN setup at all?

Thanks again,