Home HVR Real-time Replicator Community Discussions SQL AlwaysOn Availability Group – Readable Secondary Reply To: SQL AlwaysOn Availability Group – Readable Secondary
Reply To: SQL AlwaysOn Availability Group – Readable Secondary
Alternatively, if sysadmin role is an absolute requirement, can we use a SQL instance that is NOT part of an Always On Availability Group, a stand-alone instance, with the source database being restored / maintained via SQL transaction log replication with standby files (to make it readable)? We currently execute SQL transaction log dumps every 5 minutes anyway, therefore restoring to this replica with standby files would be very simple. The HVR software could have sysadmin role to the SQL instance without any risk to the “real” production SQL instance.