There are several ways to perform MSSQL database replication, including log shipping, database mirroring and AlwaysOn Availability Groups. It is highly recommended to adopt AlwaysOn Availability Groups whenever it is possible, however, sometime we still need to use database mirroring due to the environment limitation.
This post is to outline the steps to configure the MSSQL database mirroring. The example topology is as below:
