MSSQL2012 AlwaysOn backup configuration

[optimusprime050]

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]

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

Hope this helps!!

Thanks,

Elango C

[ElanC]

Hope now AAG backups are running in your env.

Let me know your queries, if any.

Thanks,

Elango C

[ledugarte]

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]

Yep.  That is right.  Based on the backup preference backup (Federated backup) will be performed.