So, this just happened: That’s a p good idea. I’ll upvote it if you put it in User Voice. Or we just pull rank and nag @vickyharp 😀 — Kerry Tyler #BLM 🚴 (@AirborneGeek) August 3, 2018 And so, I did. Post the idea, I mean…I didn’t nag Vicky. Vote here.
Author: Jen McCown
Availability Groups and Read-Intent Secondaries
One of the perks of a SQL Server AlwaysOn* Availability Group (AG) is that the secondary nodes can handle read-only traffic. If this is configured correctly, the AG Listener will direct traffic marked “Read-Intent” to the secondary node. But we have to make sure we’ve configured things properly, both on setup, and when failing over, […]
Minion Backup: Restore to another server
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1. There are four basic steps to the setup and execution: Configure Minion Backup and let it […]