MS SQL Always On Availibility Groups / NBU 7.6.0.3

[Doctorski]

Hi,

     How is anybody handling the "passive" databases of MS SQL AlwaysOn Availibility Groups using NBU MSSQL Agent.

We are using $ALL for the databases on both clients and the passive db's fail due to them being, well, passive.

We get the error below.

11:49:43.210 [3236.5084] <16> CODBCaccess::LogODBCerr: DBMS MSG - 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.>.

Any tips would be great.

Thanks - Darren

[RiaanBadenhorst]

Why would you want to backup the passive copy?

[Doctorski]

Hi Riaan,

             I don't, but want to use DATABASE $ALL for anything else on there, be ready if there is failover, just in case we are not informed of the failover.

Not that we would ever be not informed

[Marianne]

Unfortunately no official NBU documentation other than:

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

in the DB SCL: http://www.symantec.com/docs/TECH126904

[Doctorski]

Ok thanks Marianne, thought I'd ask in case anybody had anything clever developed.

I will look into trying to identify which are passive and possibly auto-maintain excludes in the batch script.

Thanks anyway.