When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener, you may have a duplicate IP situation. Resolving this isn’t QUITE as straightforward as I’d hope, so here’s our solution.
Category: SSC
Vote for a new SSMS feature: Pin files in SQL Server Management Studio
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.
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 […]