As a data professional managing SQL Servers, you need to be thinking about Windows and SQL Server patching. You want to stay up to date, but you also have to be careful because sometimes staying fully up to date comes with the risk that a new patch might break a feature you are … Continue reading SQL Server 2019 CU 16 Introduces Problems for Log Shipping
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