How can we improve SQL Managed Instance?

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 be able to restore the DB by using DMS?

Please let me know. Thanks in advance!

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

We’ll send you updates on this idea

AA shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base