Disaster Recovery
-
Build a SQL Cluster Lab Part 4
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only be installed on Node1 and Node2. FCIs require shared storage so you will make your domain controller an iSCSI target. Last you will create your FCI…
-
Build a SQL Cluster Lab Part 3
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name Object rights in Active Directory and then install your AG. You will also ensure the AG endpoints are using the dedicated network created for them in…
-
Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by creating the Windows Server Failover Cluster. In addition, you configure the Cluster Networks and a File Share Witness. Here are links to the other articles in…
-
Build a SQL Cluster Lab Part 1
This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports both Availability Groups and Failover Cluster Instances. Once you build the environment, you can use it for training purposes, POCs, or the testing of features and functions…
-
Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a SQL Server Availability Group on top of it? The technology has been around for a while, but a lot of DBAs are not aware of it. Why? All the glory…
-
High Availability and Disaster Recovery Training in Austin
I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances,…
-
High Availability and Disaster Recovery Training in Dallas
I’ll be doing a precon for SQLSaturday #447 in my home town of Dallas on October 2nd, 2015 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering,…
-
Architecture VC AlwaysOn Questions Answered
On July 15th, 2015 I spoke to the PASS Architecture Virtual Chapter about AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. Obviously we focused on the technology from an architectural standpoint. We discussed a lot of things that come into play when designing an AlwaysOn infrastructure whether it be FCIs and/or AGs. We answered questions…
-
SQL HA and DR Training in Oklahoma City
I’ll be doing a precon for SQLSaturday #422 in Oklahoma City on August 28th, 2015 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Precon in Columbus OH
I’ll be doing a precon for SQLSaturday #421 in Columbus Ohio on July 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Planning a High Availability and Disaster Recovery Plan in Puerto Rico
I’ll be doing a precon for SQLSaturday #373 in Puerto Rico on May 8th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
Planning a High Availability and Disaster Recovery Plan in Madison, WI
I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…