amazon-rdssql server
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?
I would try scripting out the operation instead of running whatever Management Studio is doing "for" you. You shouldn't need to use xp_fileexist (assuming you can validate that the files actually exist in the place the script says). Using 2012 SSMS, I am restoring to a point in time that does not coincide directly with a log backup:
The resulting script in my case was:
BACKUP LOG ... WITH NOFORMAT, NOINIT, NOSKIP, NOREWIND, NOUNLOAD, NORECOVERY
RESTORE DATABASE ... WITH FILE = 1, NORECOVERY, NOUNLOAD
RESTORE LOG ... WITH FILE = 1, NORECOVERY, NOUNLOAD
...
RESTORE LOG ... FROM DISK = [...path from line 1...] WITH NOUNLOAD, STOPAT = <time>
You cannot exclude parts of the database from backup and restore in the sense that those parts disappear or just become empty. SQL Server requires that all filegroups are either current or offline. You can bring non-current offline filegroups online by making them current by restoring enough backups.
A database is an inseparable entity when it comes to data and consistency.
If you could empty partitions/tables by not restoring them you could break trusted foreign keys and indexed views.
Best Answer
There is a limit of 10 backup files.
When attempting to restore from more than 10 backup files, the following error occurs: