Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

Question

Post reply

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

Brian Knight

One Orange Chip

Points: 27249
More actions
July 8, 2001 at 12:00 am

#104448

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp
Brian Knight
Free SQL Server Training Webinars

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

pparuchuri@hotmail.com Valued Member Points: 66 More actions · Answer 1

you mean for all clusterd environments(active/active,active/passive)

Edited by - pparuchuri@hotmail.com on 10/10/2001 4:53:43 PM

jamyer Default port Points: 1433 More actions · Answer 2

I think the number one reason people have trouble with Clusters is they slap it together without doing a lot of research and study. A cluster is much more than just a fail-over SQL server scheme! For some it may be their first experience with Advanced server, SQL Enterprise Edition, Microsoft Clustering technology, and fail-over logistics. Not to mention clients that think since they spent $$$ dollars on the setup it will be more stable and require less labor than monolithic configurations.

nemomty SSC Rookie Points: 31 More actions · Answer 3

In wich directory do you put the files for the second installation? In the same path where the files from the first node are?

Brian Knight One Orange Chip Points: 27249 More actions · Answer 4

quote:
In wich directory do you put the files for the second installation? In the same path where the files from the first node are?

If you accept the default, it will go into a separate directory under the Program Files\MSSQL$InstanceName directory. It goes on the local drives for each server.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars

Arkady75 Valued Member Points: 68 More actions · Answer 5

I have not an added option for a virtual server in the setup

Do you have an idea why ?

Thanks

Edited by - Arkady75 on 11/28/2002 10:17:49 AM

Arkady75 Valued Member Points: 68 More actions · Answer 6

Hum, i need maybe the Enterprise Edition of SQL 2000 and not the Standard Edition....

Isn't it ?

Brian Knight One Orange Chip Points: 27249 More actions · Answer 7

That would do it. Clustering is an Enterprise Edition feature only.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars

Rachell-76794 Ten Centuries Points: 1067 More actions · Answer 8

Can you specify if you need apply either window or sql server service pack, how do you apply, Can these be down while server on line?

Thanks

Rachel

shwetha Ten Centuries Points: 1248 More actions · Answer 9

Hi Brian, your article is excellent, do you have any article on moving from active passive to active active cluster, I really appreciate -

Thanks & regards!

Robert Manello SSC Journeyman Points: 75 More actions · Answer 10

Great article. I was searching for a while for an automated means to be able to schedule failovers in my active/passive environment (to apply service packs that require a reboot for instance) -- I found a helpful article for this that I thought others may be able to utilize:

http://www.agilist.com/articles/clusterFailover.asp

Dony Ten Centuries Points: 1317 More actions · Answer 11

Could you also offer Windows server 2003 and SQL 2000 installand config?

Robert Stewart Hall of Fame Points: 3399 More actions · Answer 12

Or a Win 2003 and SQL 2005 configuration. With 2008 coming out shortly, I wonder how much longer MS will be supporting 2000.

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 13

I have been really greatfull if this article was for Windows 2003 & SQL Server 2005. As SQL Server 2000 is set to expired APRIL 2008. So it was great to see this article coming after 8 years.

icata Hall of Fame Points: 3176 More actions · Answer 14

Thank you very much for this article, it helped me a lot few years ago when I had to install my first cluster.

I think it would be also interesting to see what are the changes between clustering Win 2k3/SQL2k5 versus Win 2k8/SQL2k8, or an overview of Win 2k8/SQL2k8 clustering.