That's interesting point. since AWS RDS doesn't have a "file system behind"( of course it has but as end users, we couldn't see it).

I guess you are backing up .bak on your local machine, and open SSMS query window to run restore stmt against the .bak file.

is this what you have tried, could you please post your script that backup and restore to AWS here?

thanks,