How to fail Azure SQL DB over to a secondary nore March 16, 2018 two options: 1. change the pricing tier (and change it back to avoid unexpected cost increase on your monthly bill) 2 run this command - DBCC STACKDUMP( 'Manual Failover – Reason: something' ) Read more