locked
Migrating SQL Server to a Different Azure Region RRS feed

  • Question

  • Hi,

    As a business intelligence analyst, I’m somewhat new to this realm of work, but eager to learn more about SQL server administration. Please bear with me if my question below does not make sense.

    I'm tasked to migrate our Azure SQL server to a different Azure region. My goal is to migrate the server (let’s call it ServerToto) to the new region with the same server name assigned as alias, so we don't have to adjust the connection string for the software and dashboards that are connecting to the ServerToto right now.

    Will this 3-step approach below work? What are the other thing I might have to take into consideration?

    Step 1. Replicate ‘ServerToto’ and failover to a new server named ‘ServerToto2’ in the new region.

    Step 2. Delete ‘ServerToto’, and wait for x hours/days for the server name to be freed up. (This article indicates it takes at least 5 days for the server name to be freed up: https://blog.pythian.com/three-hidden-azure-sql-database-gotchas/ Any official information on this?)

    Step 3. Assign ‘ServerToto’ to ‘ServerToto2’ as alias.

    In another similar discussion (see link below), it says, “if you want to re-create the server again in the same subscription it will be recreated immediately with no limitation”. However, since I’m moving to a new region, it might not be applicable for me?

    https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/04/server-name-has-already-been-used-after-you-deleted-it/

    Thank you very much.

    Thursday, March 14, 2019 2:26 PM

All replies

  • Hi,

    When a server is deleted it is soft deleted, which allows support to restore it quickly. Microsoft retains the server in this state for up to five days, which reserves the name for that period. Here is a good discuss.
    Inconsistency with Azure SQL Server deletion

    If you need to have the same server name, you may want to call Azure Supports for better help. Please refer to Migrating Azure services to new regions.

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, March 15, 2019 2:12 AM
  • Why don't you use ASR Azure-to-Azure region replication and fail-over the server to another region and delete the source one.

    https://docs.microsoft.com/en-us/azure/site-recovery/azure-to-azure-quickstart

    • Proposed as answer by Mara Ram Tuesday, March 19, 2019 2:06 AM
    Tuesday, March 19, 2019 2:06 AM