Tag Archives: High Availability

Blast from the past – Windows 2003 Failover Clustering

Recently, I had the opportunity to work on a project involving a 2 node, clustered Windows File Share. No big thing you say. The interesting was that it was a Windows 2003 cluster. This was the time that Failover Clustering … Continue reading

Posted in General Information, Lab Projects | Tagged , , , , | 9 Comments

SQL Failover Cluster – Part 4

Continuing on from Part 3 of this series on SQL Server Failover Clustering, the next step after Creating the Distributed Transaction Coordinator (DTC) Service on the failover cluster is to Create the SQL Server instances on each participating node. This … Continue reading

Posted in Lab Projects, Service, Tips | Tagged , , | 2 Comments

SQL Failover Cluster – Part 3

As mentioned in Part 2 of this series on SQL Server Failover Clustering, the next step after Creating the Windows Failover Cluster is to Create the Microsoft Data Transaction Coordinator (MSDTC) Service. This post will present the detailed steps that … Continue reading

Posted in Lab Projects, Service, Tips | Tagged , , | 1 Comment

SQL Server 2008 Database Mirroring

This post is going to cover SQL Server Mirroring. SQL Server 2005 will support mirroring, but it’s best to have SQL Server 2008 or SQL Server 2008 R2 Enterprise installed on your servers. The Level 7 Tech Group lab is … Continue reading

Posted in Lab Projects, Reviews, Tips | Tagged , , , , , , , | 6 Comments

Windows Failover Clustering

As a Business Intelligence (BI) Build Engineerworking in Microsoft IT Services, I was brushing up on SQL Server 2008 High Availability options when I found two books on the subject in the Microsoft Library on the subject and checked them … Continue reading

Posted in General Information, Products, Reviews, Tips | Tagged , , , , , , , , | 2 Comments