SQLServerCentral.com Content tagged Clustering

Clustered Instances

Fri, 16 Dec 2011 07:00:00 UT

The Future of SQL Server Monitoring
"Being web-based, SQL Monitor
enables you to check on your servers
from almost any location" Jonathan Allen.
Try SQL Monitor now.

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.

The Future of SQL Server Monitoring
Monitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

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.

SQL Script to check SQL Server cluster Nodes.

Tue, 15 Mar 2011 06:00:00 UT

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

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

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.

The Future of SQL Server Monitoring
"Being web-based, SQL Monitor
enables you to check on your servers
from almost any location" Jonathan Allen.
Try SQL Monitor now.

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.

Windows Server 2008 Cluster feature

Fri, 27 Nov 2009 07:00:00 UT

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.

Estimating the table size...

Thu, 02 Jul 2009 06:00:00 UT

This is an effort to program the "Estimating the Table size" section given in BOL.

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.

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.

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.

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.

Cluster Information

Fri, 08 May 2009 06:00:00 UT

This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources

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.

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.