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.
459 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,936 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.