UNSOLVED

morrisos1

updated

11 years ago

M

morrisos1

7 Posts

0

790

April 2nd, 2015 06:00

SQL 2012 Availability Group Backup

Hello,

I am trying to configure a backup for a database in a 2-node AG.  I have loaded the Windows client and SQL client on both nodes in AG.

I have the backup preference in AG set to Prefer Secondary.  Replicas are both set to Readable.

When I select the client in Avamar Administrator I can only see the databases not in AG (the local system db's on the selected client).

I did run the Cluster Configuration tool on primary node choosing the SQL Always On option and it successfully ran it's config and registration.

Can anyone please suggest something I am missing in that I can't see the AG database?

Many thanks for any help.

Morrisos

  • sddc_guy

    159 Posts

    484

    0

    Posted April 3rd, 2015 07:00

    Did you check the proper rights ?

    If using windows auth, you need to grant nt authority\system

    serveradmin role, otherwise discovery will fail !

    serveradmin.png

    see also avamar sql server user guide

    servre2.png