optimusprime050
Not applicable

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.

4 Replies
ElanC
3 Silver

Re: MSSQL2012 AlwaysOn backup configuration

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

0 Kudos
ElanC
3 Silver

Re: MSSQL2012 AlwaysOn backup configuration

Hope now AAG backups are running in your env.

Let me know your queries, if any.

Thanks,

Elango C

0 Kudos
ledugarte
3 Argentum

Re: MSSQL2012 AlwaysOn backup configuration

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.

0 Kudos
ElanC
3 Silver

Re: MSSQL2012 AlwaysOn backup configuration

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

0 Kudos