Unsolved

This post is more than 5 years old

7 Posts

730

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

159 Posts

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

Top