Error doing restore from s3 in sql server
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
[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.
- 最新
- 最多得票
- 最多評論
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.
相關內容
- 已提問 1 天前
AWS 官方已更新 2 年前- AWS 官方已更新 2 年前