Log-Shipping

SQL Server 2019 CU 16 Introduces Problems for Log Shipping

 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 …

Continue reading

How To Use Powershell to Configure Multiple Databases 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 …

Continue reading

Steps to Catch Up Log Shipping Secondary

 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 …

Continue reading

You Really Should Stay Current on Cumulative Updates

 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 …

Continue reading