旧来のバージョンでSQL Serverデータベースに自動フェールオーバーソリューションを構築する場合、Microsoft Cluster Services（MSCS）を利用する必要があった。MSCSはコンピュータのクラスタリングで、アプリケーションの冗長性を実現するWindowsサービスの1つだ。

SQL Server 2005 SP1でデータベースミラーリング機能がようやく提供される。Microsoft Cluster Serviceよりもシンプルなフェールオーバーソリューションだ。企業はそれぞれの状況に応じて、ミラーリングかクラスタリングかを選択する必要が出てきた。 2005年11月のSQL ...

Last month I attended a session on Failover Clustering at the SQL PASS Summit Conference and it was very enlightening. I have not done too much with SQL Server Failover Clustering except in test mode ...

DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...

Definitely, failover clustering is a hot topic within the SQL community – specifically if you are trying to obtain high availability and minimize data loss. My latest title SQL Server 2008 Management ...

Okay, here's the deal, we accidently got SQL Server 2000 the normal one, not the Enterprise Edition sucker. Does anybody know if it's possible to get clustering working with it? All the white papers I ...

Database virtualization vendor Xkoto has its eye on enhancing cloud computing and cluster management for Microsoft SQL Server and IBM DB2. The company released GridScale 5.1, the latest version of its ...

We plan to implement a 2-node MS SQL 2000 or 2005 cluster and I need to know the requirements.<BR><BR>Here are some info that I gathered:<BR><BR>* Windows Server 2003 Enterprise or Datacenter ...