HADR

Failing over AlwaysOn Availability Groups

Failing over AlwaysOn Availability Groups

Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail…

Availability Group fail-over test with PowerShell

I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency that a separate data center implies is more than my application can handle for its writes….

Backup testing with PowerShell

This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your…

ApexSQL’s Response to the Community

The end of last year I did a review on ApexSQL Restore, a tool used to attach SQL Server native backup files to a database instance. Check out the full review here if you missed it. Just last month (Aug 12th),…

Are your backups enough?

“You only need one thing; a backup or a résumé. Never both.” This quote certainly summarizes a very important piece of being a DBA. You must be able to recover from a disaster. There are many ways to offer redundancy…

Managing Multi-Instance Cluster Failovers

Managing Multi-Instance Cluster Failovers

A couple of weeks ago I was reviewing my daily news feeds and a featured post on SQLServerCentral.com caught my eye. Michael Lacy‘s post on Managing MaxMemory Values on an Active-Active Two Node Cluster provides a solution to the problem of…