Thanks for the reply. Can i know what is the difference between AWS EC2 and AWS RDS?
RIght now i am using Bastion server to RDP to SQL server.
FOr backup and restore- i have performed sql native full backup on my local machine SQL instance and moved that .bak file to Bastion via REmote desktop local shared resource and from Bastion server i moved the file to AWS SQL instance.
From there i was able to restore the database backup.
but moving the files is taking more time to Bastion server.
Is there any special way to move move the files?