Steps to restore database which is part of Trans replication and Allwayson db

  • We have a Setup where replication and AG is configured as below.

    Servers:Node1,Node2

    ==>Node1

    Instances:

    SQLNode1/distributor,

    SQLnode1/Pub,

    ==>Node2

    Instances:

    SQLNode2/distributor,

    SQLnode2/Pub,

    --> Distributor database is configured as remote server and configured in AG between SQLNode1/distributor and SQLNode2/distributor

    -->Both Publisher(DB-A) and Subscriber(DB-A-reporting) database are in same instance SQLnode1/Pub and SQLnode2/Pub which are on configured on Same AG group.

    We have request to refresh/restore the Publisher(DB-A) on the  SQLnode1/Pub and SQLnode2/Pub

    Could you please let us know the steps involved to restore of database which is part of replication and Always On Availability Group.(like steps in involved in configuring AG and replication after restoring of database)

  • 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