Thanks for the reply. Can i know what is the difference between AWS EC2 and AWS RDS?
AWS RDS is a web service that allow you to create a sql server database on it. It is designed to minimize the administrative work, for instance you don't have to create any Maintenance Plan to execute full backup and log backup. For more details you can see the feature of RDS on its website
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?
Copy from local to RDP, it really depends on the networking speed and the size of your .bak file, how big is your .bak file, have you think about compressing it then move to AWS server?
[p]I will consider the backup and restore is the best way to move your local DB to AWS sql server.[/p]