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?

Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande