How can I do a manual VDI Backup of an SQL AlwaysOn DB?

Thank you Michael,

Have you tried both the SQL plug-in and also the SQL GUI?

Have you granted the required permissions described in the documentation?:

In the SQL Management Studio > Security > Logins > Login Properties page, grant the SQL Server system dbcreator, public, and sysadmin permissions to the Windows logon account, as shown in the following figure. Provide these permissions to the NTAUTHORITY\SYSTEM user and DOMAIN\USER in the SharePoint environment.

To perform backups of secondary replicas by using NMM 3.0 SP1, set the Readable Secondary option of SQL Server 2012 AlwaysOn configuration to “Yes.” Enable this option for the primary and the secondary replicas, because during failover of an availability group, the secondary replicas become primary and vice versa.

Could you please attach some screenshots?

Are you able to backup any DB at all?

Thank you,

Carlos

Hi Carlos

NetWorker Server 8.1.1.9

NetWorker Client 8.1.1.9

NMM 3.0.1.2

SQL 2012 AlwaysOn

Hello,

What NW server and client versions are you using?

Also, what is the NMM version you have installed, and what is the SQL version?

SQL federated backup is not supported for an Availability Group that is configured with SQL virtual server instances.

Thank you,

Carlos

Hi Carlos

- I have only tried with NMM SQL GUI.

- The User has sysadmin permisssions on the SQL System.

- All Readable Secondary Option is enabled on all replicas.

- I can run backups from NetWorerker Server without any problems but the SQL Admins will do some manual backups from the client.

Regards

Michael

Hi Stephane

Thank you for answering my question.

You are right, it is not supported