exec msdb.dbo.rds_backup_database Fails with S3 Error

Question

Hi  
  
I've been using msdb.dbo.rds_backup_database to backup SQL Server databases to S3 for 2 years, but in the last few weeks I've had one specific database failing intermittently with the errors  
  
Aborted the task because of a task failure or an overlap with your preferred backup window for RDS automated backup  
A nonrecoverable I/O error occurred on file "XXXXXXXXXXXXX"  
and  
S3 write stream upload failed. Encountered an error while uploading an S3 chunk  
  
The first error is a red herring in that the backup fails, even if I run it during the day, well away from backup or maintenance windows  
  
I backup many databases this way, but just this one specific database fails - everything else works fine  
  
Anyone know why, and how to sure it please ?

Thanks  
STEVE

Answer

I have the same problem. Works fine on other databases on the same RDS database server.  
  
Mine always gets to "Completed processing 100% of S3 chunks. "   
and then fails.  
  
Write on "6A28AB7B-2334-4745-AC01-XXXXXXXXXXXXXX" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)  A nonrecoverable I/O error occurred on file "6A28AB7B-2334-4745-AC01-XXXXXXXXXXXXXX:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).  BACKUP DATABASE is terminating abnormally.   
  
Unable to write chunks to S3 as S3 processing has been aborted.   
  
Any ideas? It used to work for me too. maybe they screwed up an update :(  
  
Edited by: LukeSydneyAWS on Feb 16, 2020 9:38 PM  
  
Edited by: LukeSydneyAWS on Feb 16, 2020 9:38 PM

Answer

mine has CDC turned on. do you know if your database has CDC switched on?

exec msdb.dbo.rds_backup_database Fails with S3 Error

Relevant content