MS SQL Server RDS, Backup / Restore disk space issue

0

Hi,

I have a very weird issue on SQL Server Standard 2019 RDS, we've taken a backup of our on-premises database, but when we try and restore the backup from S3, we get the following error:

[2023-05-30 09:15:22.377] Aborted the task because of a task failure or a concurrent RESTORE_DB request.
[2023-05-30 09:15:22.453] Task has been aborted
[2023-05-30 09:15:22.457] There is not enough space on the disk to perform restore database operation.

Then as a test I installed SQL Server express 2019 locally and restored the backup without issue, I also confirmed the size of the database, by running the scripts on the troubleshooting page:

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024/1024 SizeGB
FROM sys.master_files
WHERE DB_NAME(database_id) = '[DB_NAME]'
GO

Database SizeGB = 7 Log SizeGB = 0

My RDS configuration is Allocated storage = 75GB, Maximum Storage threshold = 125 GB.

If I goto Monitoring FreeStorageSpace = 79.5GB and FreeLocalStoragePercent is 20.

I don't know what to do anymore, I've also tried rebooting the RDS, this worked before on the same instance, the dev dropped the database and tried a new restore, I don't know if there might be something I should run to clean up, anyone have any ideas, please?

Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen