ADD FILE on the primary of an availability group reaches every secondary as a log record. If the same path doesn’t exist on a secondary, the operation fails and data movement is suspended. Here is how to resume it.
SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031
In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.
What Is NewSQL? Distributed SQL Databases Explained
What is NewSQL? It’s the name for relational databases that spread data over many servers and still give you SQL and ACID transactions. This post walks one orders table through key ranges, replicas and a majority vote.
Horizontal and Vertical Scaling for Databases
Horizontal and vertical scaling solve different SQL Server capacity problems; compare larger machines, additional nodes, and the costs each brings.
Log Shipping to a Readable Standby: Restores vs Report Users
Configure a readable standby for log shipping, balance restore jobs with report users, and measure copy and restore delay.
SQL SERVER – Get High Availability with SQL Server 2012
SQL Server 2012 offers several High Availability options, including up to four active secondaries. Here is what they give you and how a course can help.
Geo-Replication for Azure SQL
Geo-replication for Azure SQL protects against regional failure through readable replicas or failover groups; learn lag, routing, and drills.