File cabinet image

Manually failover all databases in an SQL Server Database Mirroring configuration

How to manually failover an SQL Server database mirroring session? A manual SQL Server failover can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I’ll show you how to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017+.

Read more

Loading time: 85 queries, 0.175 seconds using 12472760 bytes memory. Peak memory usage: 12892384 bytes.