Netbackup 7.5 on SQL 2012 virtual machines with always on

[aetius1980]

Hi,

 Is it possible to have 2 Vmware vms both running SQL 2012 with databases in an AlwaysOn Availability Group and simply point Netbackup to the availability group listener?

When you create an availability group, you can specify backup preferences for each copy. I'd like to know if Netbackup can backup according to the listener and availability group preferences or whether Netbackup specifically needs to be pointed at a SQL instance?

Thanks

[Marianne · Accepted solution]

Seems this will not be possible (for now).

See NBU Agent CL: http://www.symantec.com/docs/TECH126904

1. "Always On/Availability Groups" are not supported at this time.

[aetius1980]

Thanks Marianne,

 Ok, Netbackup 7.5 supports SQL Server 2012, but maybe not the listener.

I take it, that backing up SQL Server 2012 databases involved in availability groups would simply work by pointing the backup job at a particular server and instance?

[Carlos_V]

Hello,

We have a similar issue, but in our case we want to backup the stand by node, this node is a mirror of the original active node.

We make a test but the ends with this error:

STATUS -1

INFO Error in GetConfiguration: 0x80770003.

INFO The api was waiting and the timeout interval had elapsed.

INFO ODBC return code <-1>, SQL State <37000>, SQL Message <3059><[Microsoft][ODBC SQL Server Driver][SQL Server]This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.>.

INFO SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>

INFO Error found executing <backup database "TEST" to VIRTUAL_DEVICE='VNBU0-5404-5896-1373055919' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.

ENDOPER TRUE