Sysadmins of the North
Share now!





Tag Archives for " T-SQL "

File cabinet image

Manually fail-over all databases in an SQL Server Database Mirroring configuration

How to manually fail-over an SQL Server database mirroring session?

How to manual fail-over mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017+. This 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 force a fail-over.

Continue reading
Skip to content