Automating Database Failover for database in DB mirroring

by BeginnerDBA   Last Updated September 01, 2017 16:06 PM

Could you please suggest the method to create DTSX/SSIS package or using PowerShell to automate the process of doing Database Failover between databases involved in database mirroring in SQL server 2012/14.

This failover if possible would need to check the logins, jobs, linked servers, Log shipping or snapshot job changes between 2 instances as pre or post check.

What is the safest and best approach to do this as we have databases which comprise from 10 GB to 10 TB.

Please advise, thanks!



Related Questions



Database Mirroring error, but everything looks OK

Updated March 28, 2017 14:06 PM

Mirrored TDE DB Performance

Updated August 10, 2018 20:06 PM


DB Migration from sql server 2014 to 2016

Updated January 10, 2018 21:06 PM