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?

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions