One of the techniques that can be used to create the SQL Server High Availability is clustering.  Clustering can be best described as a technology that automaticaly allows one physical server to take over the tasks and responsibilities of another physical server that has failed. Clustering is one of strategic needed to reduce MS SQL Server downtime, so system can serve client anytime.

With clustering technology, we can take advantage of the built-in clustering capabilities to make SQL Server Availability in ¬†the Enterprise Editions of the Windows Server family. To maximize the benefits you’ll gain from clustering, recomended to use Microsoft Windows Server 2003 ¬†significantly better than Windows 2000 Advanced Server for clustering purpose. See my sample configuration of MS SQL Server High Availability at this picture below.

… continue reading : MS SQL Server High Availability with Clustering.