2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
2
You're running into a limitation for Express edition. The actual error message is
[2023-09-28 10:36:23.137] Aborted the task because of a task failure or a concurrent RESTORE_DB request.
[2023-09-28 10:36:23.283] Task has been aborted
[2023-09-28 10:36:23.290] Maximum supported database size on SQL Server Express edition is: 10 GB.
The Microsoft documentation makes that clear as well.
Truncate the transaction log and shrink it so that both the Data and Log files don't go over 10GB and take a new backup.
répondu il y a 8 mois
0
Thanks Adrian. It's what I suspected, but I wasn't sure, because I found some sources that said the 10GB limit refers to the database only, not to the log. I asked the db owner if this is how we want to proceed, I'll report back with the result as soon as I know.
répondu il y a 8 mois
Contenus pertinents
- demandé il y a 9 mois
- demandé il y a 4 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 4 ans
- AWS OFFICIELA mis à jour il y a 2 ans
Adrian's recommendation would probably be the best way to resolve this, unfortunately the db owner choose to use a workaround to copy their db and leave the original as it is. I don't know if the inability to restore backups is the only consequence the exceeded file size limit has. Looks like we might find out eventually.