MSSQL Server Mirroring One Master Two Slave Architecture

0 votes

2 answers

68 views

sql-server database-design replication mirroring

                          Is there is any procedure to do MSSQL Mirroring with single master and multiple slave. 

[two slave X one master](https://i.sstatic.net/jy0EGoTF.png)  

Or this one. 

[One Master X One Slave for Viewing only](https://i.sstatic.net/4hpv23kL.png) 

I need a MS SQL server for viewing only that doesn't affect the master. To avoid row locking. I am currently using MSSQL Server 2017

Asked by Aaron Adonis Jaralve Velasco (3 rep)

Mar 18, 2025, 11:12 PM
Last activity: Mar 19, 2025, 11:20 PM

MSSQL Server Mirroring One Master Two Slave Architecture

Related Questions