SQL Information validator failed with error 'DatabaseSizeMoreThanMax: The source database size '45616.44 MB' exceeds the maximum allowed size of the target database '32768 MB'.

Question

While migrating data from SQL Server database to Azure SQL Database using Azure SQL Migration service. We are getting the error as below,

SQL Information validator failed with error 'DatabaseSizeMoreThanMax: The source database size '45616.44 MB' exceeds the maximum allowed size of the target database '32768 MB'.

Answer 1

Hi @ Ramana Bathi,

According to message, the source database size of 45616.44 MB exceeds the maximum allowed size of the target database, which is 32768 MB, the target database doesn't have enough space.

To resolve this issue, you can consider the following options:

1. Reduce the size of the source database: You can try to archive or delete unnecessary data from the source database to bring its size below the maximum allowed size of the target database.
2. Increase the maximum allowed size of the target database: If possible, you can increase the size limit of the target database to accommodate the source database size. This might involve changing the database configuration or upgrading to a higher-tier database service that supports larger sizes. Please refer to MS document Scale single database resources in Azure SQL Database to get more.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.