Clustered SQL Server 2005/2008 Installation Using Mount Points
If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.
2009-03-19
6,162 reads
Clustering
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2
Windows Server 2008 has a lot of differences from its previous versions and one of them is the clustering feature. How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
2009-03-10
2,991 reads
Auto notification for failover of a server and restart of SQL Server services
Learn how you can monitor the SQL Server instances for failover of a cluster or a restart.
2009-01-26
3,621 reads
Identifying Windows Volumes on a Clustered SQL Server Instance with the DMVs
I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?
2009-01-14
2,392 reads
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation
Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.
2008-10-17
2,079 reads
Setting up a Two-node SQL Server 2008 Cluster from the Command Prompt - Preparation
Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.
2008-09-17
1,778 reads
Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I
This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wrong
2008-08-15
3,246 reads
Upgrading live applications to SQL Server 2005
Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.
2008-07-24
3,014 reads
Upgrade Active/Active cluster to SQL Server 2005
This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability.
2008-06-18
2,320 reads
How SQL Cluster Resource DLLs work with Cluster Components
In this article Nirmal Sharma explains the SQL Server internal clustering process
2008-06-17
1,729 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...