question

Shri-5469 avatar image
0 Votes"
Shri-5469 asked AmeliaGu-msft commented

sql server forums

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any suggestion

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft commented

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

but what if i have to go for cutover again . if some data left to restore or may be for any other reason

can we use same name for availability group on server A and Server B

0 Votes 0 ·

Hi Shri-5469,

Yes, you can.
Applications usually connect to the primary replica instance and the database running on it through listener, not availability group name. Please refer to What is an availability group listener which might help.
So you can use the same name for availability group on server A and Server B.

Best Regards,
Amelia


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.


0 Votes 0 ·