SQL 2005 in cluster - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL 2005 in cluster

Author

Topic

Ikariux
Starting Member

16 Posts

Posted - 2008-09-08 : 02:09:54

Hello

I have some questions about clustering. I have two Windows 2003 enterprise servers and want to cluster them with SQL 2005 installed.

questions:

1. After i will cluster windows 2003 should i cluster sql 2005 also?
2. what version of sql 2005 should i use? is sql 2005 standart enough?
3. sql 2005 must be installed to both windows 2003 servers before clustering?

Thank you for help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-08 : 11:01:33

1. Yes, select the option in the SQL installation
2. It depends on what you neeed
3. No, the SQL installation handles it

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2008-09-08 : 11:35:50

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

SQL Server 2005 Standard supports only two nodes for clustering.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources