Automate Log Shipping Failover

Is it possible to automate Log Shipping Failover and Recov开发者_如何转开发er 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?

Log shipping is manual failover: you'd use it for "disaster recovery"

You'd use Database Mirroring for automatic fail-over: this is "high availability".

You can use both though.

So, no, if you want to achieve this you're using the wrong feature of SQL Server

Log Shipping Failover

No automated failover. If automatic failover is required, consider Mirroring instead. To failover: - Stop the jobs

• Take a tail of the log backup (BACKUP LOG … WITH NO_RECOVERY)

• Apply tail of the log backup to secondary with a RESTORE LOG ... WITH RECOVERY

• If required, configure log shipping in reverse direction See this

Allows for rolling patches an upgrades - Upgrade secondary

• Failover

• Upgrade the original primary (now secondary)

See this