MS SQL Server High Availability with Clustering

Author : admin

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.

23 June 2009 at 22:28 - Comments

High Availability and Secret of Number Nine

Author : admin

On a public service demands that always ready in 24 hours, needed a high availability management that make sure system is always running. Therefore, if we want to  create a system with a high level of availability is not as easy and simple as installing a piece of software and hardware, or using not just run a command periodically with a syntax xxx –full-online.

If we want to build system with high availability,  it’s needed best platform and system to make sure public service always running anytime from node to node. Analyze and performance test of each element, constructing and testing an end-to-end solution that encompasses people, process, and technology is the only tried-and-true method of preparing for a potential disaster. Redundant technology for availability only provides the end physical manifestation of a larger, agreed-on goal that also takes into account security and performance.

… continue reading : High Availability and Secret of Number Nine.

23 June 2009 at 15:02 - Comments