Unsolved
This post is more than 5 years old
7 Posts
0
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


sddc_guy
159 Posts
0
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 !
see also avamar sql server user guide