Share via

Question on Managed Instance in Azure

anil kumar 1,646 Reputation points
2021-02-16T07:25:03.443+00:00

Hello,

Microsoft says "SQL Database and SQL Managed Instance leverage the Always On availability group technology from the SQL Server instance for replication and failover." - Somewhere I heard there are 2-3 replicas created for your managed instance in the background.

My question is - can we access secondary replicas for managed instance? Actually we are exploring how to persists objects in TempDB in Azure which could survive failover and maintenance without making change in our applications. We wanted to create those objects in Model and TempDB databases on primary and secondary servers of Managed instance.

Sorry, I don't have enough azure credit remaining so unable to create MI and see for myself.

Appreciate your insightful response. Thank you.

Azure SQL Database

Answer accepted by question author

Anonymous
2021-03-04T16:21:07.383+00:00

@anil kumar

We have response from the Product team regarding this issue:

Can we access secondary replicas for managed instance? Actually we are exploring how to persists objects in TempDB in Azure which could survive failover and maintenance without making change in our applications. We wanted to create those objects in Model and TempDB databases on primary and secondary servers of Managed instance.
You can access geo-secondaries on managed instance. Objects in model/tempdb are not replicated to the geo-secondary, so they would need to be created independently on both the geo-primary and geo-secondary.

Regards
Navtej S

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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