Back from Azure

Andrea Caldarone 61 Reputation points
2020-10-05T07:49:29.083+00:00

Hello,

I've an Azure Managed Instance, my task is to take databases from the cloud and bringing them back online in an on-premise installation.
I've seen no documentation on this topic.

Anyone could point me to some documentation?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,251 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. tibor_karaszi@hotmail.com 4,301 Reputation points
    2020-10-05T08:49:21.347+00:00

    You can't restore from MI to an on-prem SQL Server since the MI is a higher version than your On-prem version, That leaves replication if you need to be on-line (at least I know of no other options to go online from MI to on-prem).

    1 person found this answer helpful.

  2. Ronen Ariely 15,081 Reputation points
    2020-10-05T08:29:51.167+00:00

    Good day @Andrea Caldarone ,

    I've seen no documentation on this topic.

    This make sense. Microsoft push for the other direction = migrating to the Azure and not vice versa. But we can guide you on your options.

    I've an Azure Managed Instance, my task is to take databases from the cloud and bringing them back online in an on-premise installation.

    The solution should fit your needs, and first main question which I would ask is: Do you need the database to be online during the migration or not

    Option 1: If you do not care about keeping the database online then backup and restore can fit you. Azure Managed Instance support full backup with COPY_ONLY to Azure blob. For example:

    BACKUP DATABASE Your_Database_Name  
    TO URL = 'https://mytorageaccount.blob.core.windows.net/myfirstcontainer/Your_Database_Name.bak'  
    WITH STATS = 5, COPY_ONLY;  
    

    For more information check the documentation about BACKUP: https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=azuresqldb-mi-current#azure-sql-managed-instance

    Option 2: you can use replication to on-premises

    0 comments No comments

  3. Andrea Caldarone 61 Reputation points
    2020-10-05T08:36:01.03+00:00

    hello pituach,

    forst of all thank you for the answer.
    I need the database to be online during the process.
    Could I use a sort of manual log shipping?

    1. backup full to azure blob
    2. restore on premise from azure blob with norecovery
    3. backup log from managed instance to azure blob
    4. restore log with norevocery from azure blob?

  4. Andrea Caldarone 61 Reputation points
    2020-10-05T12:29:56.61+00:00

    Transactional replication? The databases are in excess of 2TB (Dynamics Navision)


  5. Andrea Caldarone 61 Reputation points
    2020-10-05T12:58:56.49+00:00

    @tibor_karaszi@hotmail.com what if I could go offline? What option I have?

    0 comments No comments