This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
I have created an AD setup. Joined two sql vms(primary and secondary) into that AD.
I have then installed failover clustering on both the sql nodes, and created a cluster.
Then I have enabled SQL Server Always On Availability Groups.
Next, while configuring SQL Server Always On, I have created Hadr endpoints and created a db in primary node, took backup and restored it in secondary.
Then created a availability group in primary. While restoring db to AG in secondary, facing error that availability group and its local availability replica does not exist.
Did you also run CREATE AVAILABILITY GROUP on the intended secondary?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Hi Sree Harshita Maddala,
It seems like the AG metadata for that group isn’t present on the secondary or the secondary SQL instance hasn’t Joined the AG yet.
Try to JOIN non executed on secondary AG (instance level). Looks like you created the AG on the primary, but on the secondary instance you must run. Without JOIN, the secondary has no local replica metadata and will throw this error when you try to join databases.
Let me know if that worked for you.
Thank You.