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?

답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠