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

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

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 ...

While the cloud continues to grow in popularity for many, if not most, enterprise applications, IT departments remain reluctant to trust public clouds, including the Google Cloud Platform, for ...

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 ...

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 ...

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 ...

AI thrives on data but feeding it the right data is harder than it seems. As enterprises scale their AI initiatives, they face the challenge of managing diverse data pipelines, ensuring proximity to ...

I'm curious out there who is running sql server 2005 clusters if so what are you running MS cluster service, or veritas? Also are any of you guys using database mirroring on sql 2005. Using MSCS here ...