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
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>]
18 People are following this question.
