AlwaysOn Availability Group SQL Server 2016

Question

Hi,

I am planning to add DB (5TB) to secondary server.

This is SQL Server 2016 Availability Group (Primary+1 Secondary).

My question is?

If i Restore full backup on Secondary (With Norecovery) then enable Seeding. Doesn't works? if yes how?

Just i am planning to do some experientment.

Answer 1

Hi @Vijay Kumar ,

why you want to restore backup file on the secondary replica?

about seeding, you can refert to :
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/automatic-seeding-secondary-replicas?view=sql-server-ver15#create-an-availability-group-with-automatic-seeding

It is possible to combine the traditional backup, copy, and restore with automatic seeding.
In this case, first restore the database on a secondary replica including all available transaction logs. Next, enable automatic seeding when creating the availability group to "catch up" the secondary replica's database, as if a tail-log backup were restored

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.