I recently needed to configure log shipping for multiple databases at once as part of a migration project. I turned to PowerShell to do this. But before we get to that part, this post assumes that you’ve done the upfront work to create shares for the backups to write to and for the backups to … Continue reading How To Use Powershell to Configure Multiple Databases for Log Shipping
If you are using Log Shipping, there have probably been times that you have discovered that the Log Shipping Secondary is not up to date. Perhaps you found out by right clicking on your SQL Server instance and running the performance dashboard report for Log Shipping Status. If you are not familiar with this … Continue reading Steps to Catch Up Log Shipping Secondary
I have encountered a Log Shipping error that I want to detail as an encouragement for staying current on SQL Server cumulative updates. First, a little background. The environment is SQL Server 2014 Standard edition with a physical machine as the primary and two secondaries, both virtual machines backed by a flash storage system. … Continue reading You Really Should Stay Current on Cumulative Updates