Can I restore a SQL Server bak file which has multiple log files to Azure SQL MI?

admin

I ran the SQL to generate a bak file of Mappings SQL Server DB on our data center SQL Server 2016.

backup database Mappings to disk = ‘F:\backup\Mappings.bak’ with init, COMPRESSION, CHECKSUM

physical_name of Mappings DB:

O:\DA\USER_DATA\MappingTool.mdf

O:\DA\USER_DATA\MappingTool1.mdf

G:\DA\USER_LOGS\MappingTool_1.LDF

G:\DA\USER_LOGS\MappingTool_2.ldf

But I failed to restore this bak file to Azure SQL MI as a DB.

Can you please advise to fix this issue or if Can I restore a SQL Server bak file which has multiple log files to Azure SQL MI?

Read more here: Source link