backup server: NetWorker8.2 SP3
When I backup a server that uses AlwaysOn, can I get backups from a slave server instead of a master server?
Is it possible to backup via a slave server?
I would like to hear your comments.
NMM 8.2.3 supports AlwaysOn databases. NMM uses federated backup mechanism to backup SQL AlwaysOn Databases. Federated backup algorithm will detect the AlwaysOn group backup preference settings and perform the backup on the preferred replica / node. Hence, the backup preference been set by the DBA; Hence, DBA can set to backup from PRIMARY or SECONDARY nodes. Below are requirements to backup AAG (AlwaysOn Available group)
Hope this helps!!
The backup preference is set in SQL. Go to AlwaysOn properties -> Set backup preferences, in SQL Management Studio, and choose between:
1. Prefer Secondary
2. Secondary Only
3. Primary Only
4. Any Replica.