I'm trying to restore sql instance that is about 100gb and there is this issue of limited

The error indicates that the SQL Server edition in use enforces a hard limit of 10,240 MB (10 GB) per database. This is the limit for SQL Server Express. A 100‑GB database backup cannot be restored on an instance that is restricted to 10 GB per database.

To resolve the issue, use one of these approaches:

1. Restore to a non‑Express edition
   • Install or use an existing instance of SQL Server Standard, Enterprise, Developer, or another edition that does not have the 10‑GB per‑database limit.
   • Connect to that instance in SQL Server Management Studio (SSMS).
   • Restore the 100‑GB backup there using the normal RESTORE DATABASE process.
2. Move data in pieces to stay under the limit (only if absolutely necessary)
   • This is only viable if the target must remain SQL Server Express and the total data per database can be reduced to ≤ 10 GB.
   • Restore the backup on a higher‑edition instance.
   • Use tools such as scripts, bcp, or the Import/Export Wizard from that higher‑edition instance to move only a subset of data into one or more Express databases, ensuring each database stays below 10 GB.
3. Verify storage and file layout if restoring to Azure SQL Managed Instance
   • If restoring to Azure SQL Managed Instance on the General Purpose tier, ensure that the instance has sufficient storage and that the total size and number of database files will not cause the instance to hit the 35‑TB Azure Premium Disk limit, which can also cause CREATE/RESTORE failures even when the logical database size seems small. In that case, reduce the number of files or adjust file sizes before restore.

The core fix for the specific error message is to restore the 100‑GB database on an edition of SQL Server that does not enforce the 10‑GB per‑database limit.

References:

• Known issues with Azure SQL Managed Instance
• Troubleshoot SQL Server backup and restore operations