sql server forums

Shri 21 Reputation points
2021-02-14T02:07:14.22+00:00

Hi Expert,

I am doing migration of sql server 2012 from server A to server B. There is no connectivity between server A to server B. so will be doing backup and restore . we have availability group name called group1,group2group3. so while migrating, can we use the same availability group 'name' as it is to server B or it suppose to be different

Regards

Shree

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2021-02-15T07:07:54.68+00:00

    Hi Shri-5469,
    I think it works.
    And for listener, you can create a listener called listenername_NEW in Server B, and once everything is really for the cut-over, you can rename the listener name of alwayson from server A to listenername _old and then rename listenername_NEW to listenername.
    Here is a similar thread which might help.

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

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.