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.

Responses(4)

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)

1. Create a client for "Windows Cluster" and specify a AAG saveset in it.
2. Install NMM on AAG nodes (i.e. PRIMARY and SECONDARY replica/nodes)
3. Create client for all AAG nodes
4. Run backup. This will triggers the backup on the relevant SQL server (either PRIMARY or SECONDARY)

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.

View All

No Events found!