In this article I’ll show you how to force a failover in SQL Server 2017+, in an SQL Server Database Mirroring configuration. This can only be initiated from the principal SQL Server server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state).
