Forum Discussion

aetius1980's avatar
aetius1980
Level 2
13 years ago
Solved

Netbackup 7.5 on SQL 2012 virtual machines with always on

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

7.5
Backup and Recovery
NetBackup
Windows Server (2003-2008)

3 Replies

Sort By
  • aetius1980's avatar
    aetius1980
    Level 2
    13 years ago

    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's avatar
    Carlos_V
    Level 6
    12 years ago

    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