Error doing restore from s3 in sql server

Question

I am trying to perform a database restore from an s3 bucket, and when doing so it tells me that the size is greater than 10gb but the file weighs much less
![file size](/media/postImages/original/IMs-OI2o11QeqXxOGvWIkEug)

[2023-09-07 19:34:22.330] Aborted the task because of a task failure or a concurrent RESTORE_DB request. [2023-09-07 19:34:22.367] Task has been aborted [2023-09-07 19:34:22.367] Maximum supported database size on SQL Server Express edition is: 10 GB.

Answer

Hi there.

The reason for this error is that when the database is re-created, it takes the configuration of the original database regardless of the size of the backup file. In this case, your backup file is 5GB, but this might turn out to be a database file (.mdf) that is larger. What could have happened is that the backup was made with compression enabled, which would reduce the backup file considerably.

I hope this helps to clarify why you are getting this error.

Error doing restore from s3 in sql server

Relevant content