Share via

Back from Azure

Andrea Caldarone 66 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.
13,364 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,306 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,186 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
  3. Andrea Caldarone 66 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 66 Reputation points
    2020-10-05T12:29:56.61+00:00

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

  5. Andrea Caldarone 66 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