Tag: SQL
MSDTC – How to Cluster
Sometimes you need to cluster MSDTC as a resource in a Windows Failover Cluster. This post will describe how to do it. TL;DR Create a storage dedicated for DTC in the failover cluster. Create a cluster role for MSDTC. Configure MSDTC. Index Check CID before Clustering Create shared storage disk in Windows Failover Cluster Configure […]
How to Create a SQL Cluster – A Summary
This post is a wrapper post for several earlier post I have written. If you follow along the posts, one at a time, you will soon know how to create a SQL Server. The series of post builds up from a very basic level. However, you should have at least an elementary knowledge of Windows […]
Install SQL Server on a Failover Cluster
In this post we will look at how to install SQL Server on a Windows Failover Cluster. By doing so, we are trying to achieve High Availability in our environment. If one of the SQL servers fails or are by purpose taken offline for maintenance, the other server (node) will take over and the database(s) […]