SQL Managed Instance

  1. Show MI Private IP in Overview Blade

    My customer ask for a very simple request do you know if it possible to show in MI Overview Blade Private IP of my MI ? We already have fqdn but this will be interesting for my customer to have Private Ip

    Matthieu

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Managed instance does not support restoring database with over 280 files?

    Hi,

    I am currently trying to restore a .bak file to an MI instance. When I do RESTOREFILELIST, it looks like the DB contains 341 files (including mdf/ndf/log).

    When I then try to RESTORE the DB, I receive the error in SSMS that [Msg 41916, Level 16, State 0, Line 7 Maximum number of 280 files for SQL Database Managed Instance reached.]

    Does this mean that any managed instance does not support restoring a database with over 280 files?

    Or is this just a problem trying to restore the DB through SSMS/T-SQL? If this is a SSMS/T-SQL problem, would I…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

SQL Managed Instance

Categories

Feedback and Knowledge Base