Reputation: 805
We have an MS SQL Server running on AWS (Amazon) RDS which automatically takes backup at night. I want to restore this backup to an archive RDS instance automatically, i.e. restore the backup to another SQL Server . Whats the best way to do this? (I would prefer not to use sql scripts.)
Upvotes: 0
Views: 1701
Reputation: 781
AWS Provides facility to take Entire server(MSSQL server service and entire database) backup as a snapshot. You can create another server as original server. you can not restore database only to already running server. For that you just take database dump and restore that dump to another server ( But this is useful way only your database size is smaller).
For your reference
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html
Upvotes: 2