question

Pradeep407 avatar image
Pradeep407 asked

AlwaysON autoseed on DR site.

Hello All,

My AG has two secondaries. One secondary (HA) is good, other secondary is not (DR).

Some databases on DR is out of sync and needs to be autoseeded. How can I autoseed databases on the DR server without disturbing the HA set up?

Any suggestions will be highly appreciated.


Regards,

Pradeep

high-availabilityalwaysonsql server 2016sql-server 2017
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

You will need to remove the secondary database in the DR side then restore from your full / diff / log backups, then re-add the database to the secondary.


You can only use auto seeding when you add a fresh database at the primary.


So on secondary

ALTER DATABASE [<dbname>] SET HADR OFF

RESTORE WITH NORECOVERY

ALTER DATABASE [<dbname>] SET HADR AVAILABILITY GROUP [<agname>]

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.