Post reply

Database distribution in AlwaysOn

  • October 1, 2020 at 2:05 am

    #3792147

    Good morning all , I have an on Always On SQL server configuration where transactional replication is configured If I open SSMS I find that the distribution database is set to AlwaysOn on then I cannot find the synchronized word

    Sans titre

    thanks

     

    Attachments:
    You must be logged in to view attached files.

  • October 2, 2020 at 2:10 am

    #3792413

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 2, 2020 at 5:49 pm

    #3792576

    Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would like synchronized to show?

    Are you asking if there are any other DMV's which show the syncronisation status?

     

  • October 6, 2020 at 6:21 am

    #3793088

    as_1234 wrote:

    Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would like synchronized to show?

    Are you asking if there are any other DMV's which show the syncronisation status?

     

    What he meant to say is that the description ' (synchronized) ' near the database for all DB AG is not showing in that? May be he didnt refresh the screen or for system databases part of Distributed AG it wont be shown, I  am not sure though.

  • October 8, 2020 at 4:59 am

    #3793910

    abdalah, what is the listener name in the AG? Is the listener showing as synchronized?

    The distribution database AG needs to have a listener. When the publisher adds the distributor, it uses the listener name as the distributor name.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply