Single Managed Instance with multiple environments

MIKE82 1 Reputation point
2022-06-15T20:40:41.613+00:00

I want to migrate 3 on prem Sql Server environtments (DEV-QA-PROD) to Azure Sql Managed Instance. Every environment has around 10 databases which 350gbs in total. Do I need to create separate Managed instances for each environment (which will triple my cost) or is there any way to manage all environments in 1 single managed instance?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2022-06-16T03:03:01.457+00:00

    You won't have to triple your costs as Azure offers up to 57 percent discount for Azure SQL Database/Managed Instance non-production workloads. You can save even more, 65 percent, when you make use of Azure reservations as explained on the same offer.

    Make use of the cross-instance point-in-time restore option in Azure SQL Database Managed Instance to help you refresh your Dev and Test environments with ease as explained here.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.