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, […]
Category: sql server
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 […]
The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’
Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let’s take a quick look anyway. Because, you know, it comes up all the time.