AlwaysOne see all the bases on the primary server? Why?

Salves 501 Reputation points
2020-08-31T01:53:26.717+00:00

Hi,

when i access a listerner i see all the bases of the primary server.

I notice that I see the base that was synchronized and also all the others that were not synchronized.

Is that so by design?

Did I imagine that it would only show the replicated base in AlwaysOne?

Thank you.

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,013 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shashank Singh 6,251 Reputation points
    2020-08-31T07:38:44.803+00:00

    By bases you mean the databases. If so, bases is not the correct term please call is database. Now to your question yes connecting with listener is same as connecting to database using the instance name so you will see all the databases (both which are part of AG and which are not). also you will see databases which are synchronized and not synchronized. This is by default feature

    0 comments
  2. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2020-09-01T05:32:59.08+00:00

    Hi @Salves ,

    Enter the AG listener name in the server name field is same as enter the primary replica instance name, it will connect to the primary replica instance.

    If the bases that your mentioned is databases. Yes, you will see all the database of the primary server. It is by design.

    Best regards,
    Cathy

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.

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.