SQLServerCentral.com Articles tagged Clustering

Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

Fri, 13 Apr 2012 06:00:00 UT

This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.

Tips for Upgrading a Cluster to SQL 2008 - Part 2

Tue, 20 Mar 2012 06:00:00 UT

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008

SQL Server 2012 Active/Active Cluster in Hyper-V

Mon, 13 Feb 2012 07:00:00 UT

Learn how to create a SQL Server 2012 Active/Active cluster in Hyper-V using an iSCSI SAN

SQL 2008 R2 Cluster Setup: Easy? Not So Much.

Tue, 29 Nov 2011 07:00:00 UT

The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.

Tips for Upgrading a Cluster to SQL 2008 - Part 1

Mon, 14 Nov 2011 07:00:00 UT

This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008

Automatic Alert Generation in the event of SQL Server Cluster Failover

Thu, 06 Oct 2011 06:00:00 UT

We had a requirement where we were asked to generate automatic email notification in the event of a failover.

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3

Fri, 12 Aug 2011 06:00:00 UT

This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Tue, 12 Jul 2011 06:00:00 UT

Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

Mon, 11 Jul 2011 06:00:00 UT

Learn how to create a Windows 2008\SQL Server 2008 virtual cluster in this three part series.

Getting the most out of your SQL Server 2008 Cluster

Thu, 26 May 2011 06:00:00 UT

Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.

Creating A SQL Server 2008\2008 R2 Failover Cluster

Wed, 19 Jan 2011 07:00:00 UT

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance

Multi-subnet Failover Clusters

Wed, 19 Jan 2011 07:00:00 UT

Multi-subnet Failover Clusters I want to take a closer look at one of the new features in SQL Server Denali. While...

Uninstalling a SQL Server Clustered Instance

Mon, 06 Dec 2010 07:00:00 UT

I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?

Setting All Tempdb Data Files to the Same Size

Mon, 19 Jul 2010 06:00:00 UT

How to set all tempdb datafiles to same size to meet best practice.

How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster

Mon, 26 Apr 2010 06:00:00 UT

Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.

Clustered instance will not start after removing builtin admins

Fri, 16 Apr 2010 06:00:00 UT

After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.

Pre Check List for 64 BIT SQL Server 2008 Cluster Installation

Thu, 31 Dec 2009 07:00:00 UT

My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.

Understanding why there is still downtime with Microsoft Clustering

Tue, 24 Nov 2009 07:00:00 UT

I want to institute a high availability solution for SQL Server with no downtime. I am planning on using Microsoft clustering, but I have been told that in the event that the cluster moves the SQL Server from one physical server to another, that there is some downtime. Why is this so?

SQL Server 2008 Failover Clustering

Fri, 02 Oct 2009 06:00:00 UT

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.

Attribute Discretization: Using the “Clusters” Method

Tue, 04 Aug 2009 06:00:00 UT

Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.

Failing SQL 2005 Cluster Installation because of too many cpu's

Tue, 14 Jul 2009 06:00:00 UT

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.

Prepare SQL Server 2005 in a Clustered Environment for SP3

Fri, 19 Jun 2009 06:00:00 UT

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Planning Ahead - Single Node Clusters

Wed, 17 Jun 2009 06:00:00 UT

People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Setting up a SQL cluster under MS VS2005 R2 Part2

Fri, 15 May 2009 06:00:00 UT

Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Setting up a SQL cluster under MS VS2005 R2 Part1

Wed, 13 May 2009 06:00:00 UT

This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.

The Best High Availability

Tue, 28 Apr 2009 06:00:00 UT

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

The Best High Availability

Mon, 27 Apr 2009 19:42:21 UT

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.

The Best High Availability

Mon, 27 Apr 2009 19:38:52 UT

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.

The Best High Availability

Mon, 27 Apr 2009 19:28:46 UT

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.

Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4

Fri, 10 Apr 2009 06:00:00 UT

How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?