Using PowerShell to Failover Availability Groups and WFC Cluster Nodes
This article will show you how to failover an AG to another node and then move the WFC role to the same secondary…
Read MoreCategory: High-availability
About Availability Groups Database Seeding
This post will serve to describe all things regarding adding databases and trouble-shooting issues with Availability Groups Availability Group Direct Seeding: How to…
Read More
Availability Groups: Things to remember
Here are a few things to remember when working with Availability Groups: Backup and Restore NOTE: Using the Recovery Advisor GUI in SSMS…
Read More
Properly Taking a Cluster Offline for Disk Maintenance
I recently needed to replace the older, slower attached disks on our clustered SQL instance offline so as to copy each drive to…
Read More
Building an AlwaysOn Availability Group SQL Cluster
Here are the steps to build at SQL Server 2017 AlwaysOn Availability Group. We will be using Windows 2016 Standard 64-bit for the…
Read More
About Replication
Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…
Read More
Tearing down SQL Server Replication
I recently was engaged in updating the Compatibility Mode of our production databases to 110 (2012) in preparation for upgrading them all to…
Read More
Manually removing log-shipping
I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
Resolving Failover Log-shipping errors
Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…
Read More