July 28, 2005 at 9:50 am
Hello,
I searched the forums for Cluster and read couple articles on this site before posting this question.
Those two nice articles are,
http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp &
http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.asp
We have Windows 2000 Server with 2G RAM and RAID 0 and RAID 5 for hard drives.
Here are my questions,
1.) With this hardware setting, would I be able to do a cluster setup for SQL Server. (Active/Active or Active/Passive). Do I need Window 2000 Advanced Server (I think I need Advaced Server)
2.) If I need Win 2000 Advanced Server, how much does it cost (only an approximation).
3.) Can someone confirm that I need at least SQL Server Enterprise edition in order to setup SQL Clustering.
4.)Would be great if someone can quote an approximate price for SQL Server Enterprise Edition.
So basically, I need at least two of the following,
1.) Windows 2000 Advanced Server
2.) SQL Server Enterprise Edtion &
3.) Physical hardware servers
Thank you all.
R
July 28, 2005 at 10:26 am
After reading the article "SQL Server:Enterprise Vs. Standard", it answered SQL Server costs as of 2002. Has the prices changed over three year period?
July 28, 2005 at 1:39 pm
1.) With this hardware setting, would I be able to do a cluster setup for SQL Server. (Active/Active or Active/Passive). Do I need Window 2000 Advanced Server (I think I need Advaced Server)
For a cluster setup you're going to need some sort of shared media device, either an array or a SAN. You're going to need to be able to create two disk sets for an active passive setup (one of the disk sets goes to the Quorum drive, the other to SQL Server) or three disk sets (one for Quorum and one for each of the SQL Server instances) for an active/active setup.
If you are deploying on Windows 2000, you do need Advanced Server at a minimum. DataCenter also supports clustering but then you're talking about a BIG solution.
2.) If I need Win 2000 Advanced Server, how much does it cost (only an approximation).
You can't buy Windows 2000 any longer through normal channels. However, you can buy Windows Server 2003 and use its licensing... or just go with Windows Server 2003.
Windows 2000 Licensing: Microsoft: Windows 2000 Pricing (old)
Windows Server 2003 Licensing: Microsoft: Windows Server 2003 Pricing
You will need Windows Server 2003 Enterprise Edition for clustering.
Windows 2003 Downgrade rights (how you are legally allowed to install Windows 2000 after buying Windows Server 2003): Microsoft: Windows Server 2003 Downgrade Rights
3.) Can someone confirm that I need at least SQL Server Enterprise edition in order to setup SQL Clustering.
If you are using Microsoft's clustering solution, then yes, you will need SQL Server 2000 Enterprise Edition.
4.)Would be great if someone can quote an approximate price for SQL Server Enterprise Edition.
SQL Server Pricing: Microsoft: SQL Server How To Buy
K. Brian Kelley
@kbriankelley
July 28, 2005 at 1:56 pm
Thank you Brian.
What are alternates to Microsoft's clustering solution. What are advantages and disadvantages in case if you have used an alternate solution.
PS: Found this article for alternatives for Microsoft's clustering solution
July 28, 2005 at 2:19 pm
Veritas (now owned by Symantec) and PolyServe have solutions that I know of, and I'm sure there are others. I've seen PolyServe's solution demo'ed at PASS last year and it looks rather nice, but it can be pricey. You have to do a lot of individual server management with PolyServe's solution with respect to service packs and hot fixes, however, it can reduce fail-over times with the way it can implement.
K. Brian Kelley
@kbriankelley
July 28, 2005 at 3:28 pm
Found few online resources,
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply