Managed instance does not support restoring database with over 280 files?
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!
Thanks for the feedback.
General Purpose tier indeed has limitation of 280 files, this is due to nature of azure blob storage. However Business Critical tier is completely unlimited in terms of number of data files.