Reply To: SQL AlwaysOn Availability Group – Readable Secondary


Hi There,

Yes, we can use the readable secondary node for real-time capture. To do this you have to use direct read of the transaction logs from the file system (which is the fastest approach anyway). But you do need:

1) An OS user with Administrative privileges to run HVR.

2) A database user with sysadmin privileges.

Hope this clarifies.


Test drive
Contact us