Clustering in SQL SERVER 2005 Database

Hi,

Please tell me that,

What is Clustering in SQL SERVER 2005 Database?

What is the main reason of Clustering in SQL SERVER 2005 Database?

What are the advantages of Clustering in SQL SERVER 2005 Database?

How can I implement Clustering in SQL SERVER 2005 Database?

waiting for your reply with thanks

T C

You can find all the answers in Books On Line (documentation from SQL Server).

|||

What is Clustering in SQL SERVER 2005 Database?

Clustering can be best described as a technology that automatically allows one physical server to take over the tasks and responsibilities of another physical server that has failed. The obvious goal behind this, given that all computer hardware and software will eventually fail, is to ensure that users running mission-critical applications will have little or no downtime when such a failure occurs. Downtime can be very expensive, and our goal as DBA is to help reduce it as much as possible.

What is the main reason of Clustering in SQL SERVER 2005 Database?

If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?

To help boost your SQL Server's uptime.Ifone SQL Server fail in the cluster, another clustered server will automatically take over, keeping downtime to minutes, instead of hours or more.

How can I implement Clustering in SQL SERVER 2005 Database?

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

More information, see:http://www.sql-server-performance.com/articles/clustering/clustering_intro_p1.aspx andhttp://www.sql-server-performance.com/articles/clustering/index.aspx

Hope my suggetsion helps