Does Instant File Initialization supported in both Azure Managed Instance and Azure SQL?

Jan Kenneth Penaverde 21 Reputation points
2022-05-17T10:50:20.927+00:00

Hello,

I would like to ask if the Instant File Initialization is supported in both Azure Managed Instance and Azure SQL?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,631 Reputation points
    2022-05-17T11:43:50.45+00:00

    Hi @Jan Kenneth Penaverde , welcome to Microsoft Q&A forum.

    Similar query is answered in the another thread: Does Azure SQL support IFI - Instant File Initialization

    Posting here again for more reach.

    Database Instant File Initialization is only supported in SQL Server and not supported on Azure SQL Managed Instance and Azure SQL. This is also highlighted in the documentation.

    202814-image.png

    You can read more in the below article:

    How to manage & measure database file autogrowth impact on Azure SQL Managed Instance

    Please let us know if this helps or else we can discuss more on this.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Jan Kenneth Penaverde 21 Reputation points
    2022-06-28T06:24:34.2+00:00

    Thank you so much AnuragSharma-MSFT

    0 comments No comments

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.