Database Mirroring Configuration Failure scenarios

Hello all, In this blog, I am covering few scenario’s that I have encountered while configuring Database mirroring as a high availability solution for SQL Server database. For demonstration purpose, I am using SQL 2012 instances on Windows 2012 R2 server. Principal Server: SQLServer\SQL2012Mirror Server: SQLServerDR\SQL2012Witness Server: Witness\WitnessMirrored Database: DBMirrorMirroring Port : 5022Service Account: SQLServiceAccount@contoso.lab…

5

Useful information on DB mirroring

Some factors to be considered while setting up DB mirroring Database Mirroring is a software solution for increasing database availability.  Database mirroring offers a substantial improvement in availability over the level previously possible using Microsoft SQL Server and provides an easy-to-manage alternative or supplement to failover clustering or log shipping.  However, it is only supported…

0