Using Mount Points in a Microsoft SQL Cluster Server Environment

When we use an Cluster for supporting SQL Instances in medium or bigger organizations we will have some TeraByte of data. Our Infra-Structure must be prepared to grow and in some times to grow faster without the possibility of stopping to improve or migrate, so there are some Advantages of using the NTFS volume mount points feature in a Microsoft Cluster Server Environment, such as: Read more of this post


Troubleshooting Event ID 1055 Source ClusSvc – IRPStackSize and Clusters

I’ve been contacted because all the share resources in cluster Windows 2003 where unavailable.

After analysis I’ve collected this information, from event viewer Read more of this post

Listing registry keys for all resources in a 2003 Cluster

This might be useful for documentation and also for migration plans related to an SQL Cluster. Read more of this post

Disable Event Log Replication in all Cluster Nodes

A few days ago I had to analyse a problem in a cluster and I needed to disabled Log replication between all the nodes of the cluster.

If the EnableEventLogReplication registry entry is set to 1, the cluster node replicates events in the event log to all other nodes in the cluster. Tools that monitor multiple servers, report a single event multiple times, one time from each node. If you use automated monitoring, it is recommended that you disable event log replication on cluster nodes. Read more of this post

SQL Data Migration Between LUNS – Change Cluster LUNS ID’s and Drive Letters

In this specific we could not extend the LUN so we need to migrate data from LUNS, and keep the same ID’s and Drive letters, because SQL Services does not use Drive letter’s, instead use the LUNS ID. we have a Two node Windows 2003 Cluster and Two SQL 2005 Instances. Read more of this post

%d bloggers like this: