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 backups to write to and for the backups to be copied to. This will involve providing the right permissions for the SQL Server service accounts involved in Log Shipping. If you are not familiar with this, that’s perfectly fine. Check out this article in MS Docs first.