Reply To: SQL AlwaysOn Availability Group – Readable Secondary

Kirs Renaud

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.

Thank you.

Test drive
Contact us