Reply To: SQL AlwaysOn Availability Group – Readable Secondary

#8783
Mark
Keymaster

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.

Mark.

Test drive
Contact us