Unsolved
This post is more than 5 years old
1 Message
1
2218
MSSQL2012 AlwaysOn backup configuration
backup server: NetWorker8.2 SP3
Client: Windows2012
Application: MSSQL2012
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.
ElanC
53 Posts
0
November 8th, 2016 00:00
Hi OprimusPrime2,
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!!
Thanks,
Elango C
ElanC
53 Posts
0
November 15th, 2016 01:00
Hope now AAG backups are running in your env.
Let me know your queries, if any.
Thanks,
Elango C
ledugarte
96 Posts
0
November 15th, 2016 10:00
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.
ElanC
53 Posts
0
November 18th, 2016 00:00
Yep. That is right. Based on the backup preference backup (Federated backup) will be performed.