title: Automate Log Shipping Failover
body: <p>Is it possible to automate Log Shipping Failover and Recover Secondary Database in Log Shipping, something in Powershell where it checks for are there any more .trn files to be copied, restore all the unapplied transactions and recover secondary database?</p>