I am testing backups on the SQL Sever 2017 version
- when I tried to take the full backup on the secondary node got this error, even the backup preferences has set to the secondary only.
2. but, you can take copy_only backups
3. I am able to take transactional log backups on the secondary node and it is truncating the log as well.
selectstarfromyogi 