Post reply

Availability Group creation on non-primary nodes

  • April 22, 2020 at 6:10 pm

    #3745439

    Hello experts,

    I hope you are all well.

    Here is my Noob question. I ran a script like the one below to create an empty Availability Group. I see the new group on the primary replica node. But I don't yet see it on the other nodes.

    Is that because I need to add at least one database to the group? Or do I need to run the script on the other nodes? Or is it possibly some other reason?

    Thanks for any help!

    CREATE AVAILABILITY GROUP [MyAvg01]

    WITH (AUTOMATED_BACKUP_PREFERENCE = NONE,

    FAILURE_CONDITION_LEVEL = 3,

    HEALTH_CHECK_TIMEOUT = 30000,

    DB_FAILOVER = ON,

    DTC_SUPPORT = PER_DB)

    FOR

    REPLICA ON N'MYDB01' WITH (ENDPOINT_URL = N'TCP://mydb01.sample.com:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, SEEDING_MODE = AUTOMATIC, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL)),

    N'MYDB02' WITH (ENDPOINT_URL = N'TCP://mydb02.sample.com:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, SEEDING_MODE = AUTOMATIC, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL)),

    N'MYDB03' WITH (ENDPOINT_URL = N'TCP://mydb03.sample.com:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, SESSION_TIMEOUT = 10, BACKUP_PRIORITY = 50, SEEDING_MODE = AUTOMATIC, PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL), SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL))

    LISTENER N'MyAvgL01' (

    WITH IP

    ((N'100.10.11.12', N'255.255.255.0'),

    (N'101.10.11.13', N'255.255.255.0')

    )

    , PORT=6209);

    -- webrunner

    • This topic was modified 4 years, 7 months ago by  webrunner.
    • This topic was modified 4 years, 7 months ago by  webrunner.

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • April 23, 2020 at 7:10 pm

    #3745780

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

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