Nigel Fds
Nigel Fds

Reputation: 805

AWS How to restore database backup or snapshot to a different server?

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

Answers (1)

Manivannan Thirugnanam
Manivannan Thirugnanam

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

Related Questions