We have a Primary Server A with a Database. It has AlwaysOn ReadOnly Asynchronous which moves data to Server B.
Out of curiosity, is it possible to place Server B on AlwaysOn and move it to another Server C Asychronous Read Only?
We want to reduce the workload/performance on our main server A OLTP; however, we want two replicas. We're just curious.
So AlwaysOn from
- Server A → ServerB → ServerC
We want to make Database B as a primary replica on AG, which then passes to secondary Database C.