Forum Discussion
ashishkumarext
Feb 20, 2024Copper Contributor
issue while restoring the sql server backup file to azure managed instance
Dear members,
i have facing the below issue while restoring the sql server backup file to azure managed instance but i am not able to restore this DB.
please help. this is urgent
error:- Microsoft.Data.SqlClient.SqlError: Multiple backup sets in a single backup file are not supported in SQL Database Managed Instance.
Kindly refer the attached screenshot.
- olafhelperBronze Contributor
Multiple backup sets in a single backup file are not supported in SQL Database Managed Instance.I wonder about the error message, but if SQL MI complains about, the create a backup file with a single backup set = backup with option INIT