locked
Azure SQL Managed Instance DB size limit RRS feed

  • Question

  • Dear Team,

    We have a 4.8 TB SQL database on-prem, we would like to move it to Azure SQL MI.

    1. Does Azure SQL MI support this size of DB ?

    2. What is the best way to migrate it to Azure - backup on prem data and restore it in azure.

    3. are there any bandwidth guidance if we have to upload it to azure blob.

    Saturday, March 28, 2020 12:55 AM

Answers

  • Dear Team,

    We have a 4.8 TB SQL database on-prem, we would like to move it to Azure SQL MI.

    1. Does Azure SQL MI support this size of DB ?

    2. What is the best way to migrate it to Azure - backup on prem data and restore it in azure.

    3. are there any bandwidth guidance if we have to upload it to azure blob.

    Good day Afzal,

    1. Yes. In the "General Purpose" tier the storage can be configured between 32 GB and 8 TB with 32 GB increments.

    2. Let's start with HOW to transfer the data and what is not working well for most users which is using a simple internet connection in order to pass 4 TB files and hope that it will reach the destination well and fast. Actually it depend on your network bandwidth and how stable it is, but for this size I would probably prefer to send it using shippable devices.

    You can check the following document for all the options you have:

    You basically ask to transfer the data to your Azure Storage which is on the same region as your Managed Instance and on the same vNet.

    And now regarding to WHAT do we transfer...

    Follow the database migration process as presented here:
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-migrate

    In your case, you should ensure that there are no blocking issues that can prevent your database migration and if the database fit to be migrated then you can use simple native backup/restore. BUT NOTICE THAT THERE MIGHT BE MANY CASED THAT THE DATABASE DOES NOT FIT AS IT IS and in this case you can use one of the other options or prepare a local database which fit (removing un-supported entities for example) 

     


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    • Marked as answer by Afzal Atique Saturday, March 28, 2020 3:51 PM
    Saturday, March 28, 2020 4:03 AM