If we add a new filegroup on AG primary replica, will it be added on secondary replica?

Chaitanya Kiran 101 Reputation points
2021-03-11T02:15:01.587+00:00

If we add a new filegroup on AG primary replica, will it be added on secondary replica?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,307 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 22,341 Reputation points Microsoft Vendor
    2021-03-11T07:52:02.287+00:00

    Hi @Chaitanya Kiran ,

    > If we add a new filegroup on AG primary replica, will it be added on secondary replica?

    Yes. It will be added on secondary replica. I check this in my environment.

    a. Add a new filegroup in AG primary replica.

    76560-screenshot-2021-03-11-155030.jpg

    b. Check the filegroup in AG secondary replica.

    76657-screenshot-2021-03-11-155059.jpg


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.
    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.