Apr 10, 2019 · Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Apr 20, 2020 · In doing a test, I have observed that the size of the same table with the same exact DDL (created from scratch) with the same exact data (10M rows) varies drastically in our Azure SQL Managed Instance vs a local installation of SQL Server: 336 MB in the managed instance vs 198 MB in the local.

Mar 27, 2019 · The only use for database backups is to restore them into another managed instance - like if you're doing it for disaster recovery, backing them up to blob storage, and then syncing that blob to a different Azure account (in case you're worried about a malicious actor closing your Azure account, and leaving you with no backups.)

Sep 26, 2018 · Managed Instance has a single, huge, strength over Azure SQL Database, cross-database queries. If you need to query between databases and you don't want to rewrite the code, then Managed Instance is the way to go.

Aug 10, 2023 · No, log shipping to Managed Instance is not possible; it only supports the restore of full backups. See this thread: Lesson Learned #82: Azure SQL Database Managed Instance supports only COPY_ONLY restoring a database backup (was here before) And the limited syntax diagram for RESTORE in the documentation for Managed Instance:

May 27, 2024 · @Manoj Please note that Azure SQL Server isn't a thing. Either you're using a SQL Server instance in a VM in an Azure hosted cloud, or you're using one of the derivative cloud database products such as Azure SQL Managed Instance or Azure SQL Database, etc. –

Feb 19, 2024 · With any of the flavors of Azure SQL Database(Managed Instance, DTU-model, vCore, Hyperscale) you cannot disable automatic updates, Azure SQL will always run the latest version and latest cumulative update. However, you can try to change the compatibility level to 150 on user database, to see if the application can work as expected that way.

Dec 17, 2019 · I want to create a SQL Server Managed Instance in Azure that is SQL Server 2016 so I can backup and restore databases across on prem and Azure - i.e. in case we want to back out of Azure, we can do a backup and restore rather than create scripts procedure. I see the @@VERSION of my current managed instance is Microsoft SQL Azure (RTM) - 12.0.2000.8

Jul 11, 2018 · Linked servers in Managed Instance support a limited number of targets. Supported targets: SQL Server and SQL Database Not supported targets: files, Analysis Services, and other RDBMS.

Apr 2, 2019 · On Azure SQL Managed Instances, im seeing new database getting 16MB filesize growth on database and logfiles (i changed log to 128MB). I haven't been able to find online docs from MS on recommendation here. 16MB is smaller then what i would normally run with,but since i'm new to Azure MI i not sure if i should make changes here.