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.
관련 콘텐츠
AWS 공식업데이트됨 2년 전
