As a DBA I would like to include a read only replica into the always on availability group. XSLT / Crystal Reports will only be used.
Please see below
1) Primary Replica (Same Data center) Synchronous Mode Automatic Failover
2) Secondary Replica (Same Data center) Synchronous Mode Automatic Failover
3) Secondary Replica (Read Only , Same Data center for Reporting ) Asynchronous Mode
4) Secondary Replica (Off Site , DR) Asynchronous Mode
The will be a file share witness to form the quorum
My questions is will there be any problem if the read only replica for reporting is included as part of the always on availability group instead of setting Transaction Replication with the Listener.
The secondary replica (Read Only) will be used for reporting only mainly XSLT and Crystal Reports , SSRS will not be used.
Any expert feedback will be highly appreciated.