2

The AWS documentation for using native restore specifies that restoring from multiple files is allowed:

To avoid errors while restoring multiple files, make sure that all the backup files have the same prefix, and that no other files use that prefix.

The following example shows multiple-file restore.

exec msdb.dbo.rds_restore_database @restore_db_name='database_name', @s3_arn_to_restore_from='arn:aws:s3:::bucket_name/bakup_file_*'

How many files can I restore from?

2

There is a limit of 10 backup files.

When attempting to restore from more than 10 backup files, the following error occurs:

The Restore task is unable to restore from more than 10 backup file(s). Please reduce the number of files matched and try again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.