Help Center > > Best Practices> Microsoft SQL Server> Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances

Restoring Data from Backup Files to RDS Microsoft SQL Server DB Instances

Updated at: Oct 23, 2019 GMT+08:00

This section describes how to use automated or manual backup files to restore a DB instance to the status when the backup file was created.

Best Practices

  • You can create a full backup file for your DB instance and use OBS and DRS to restore the backup file to an RDS Microsoft SQL Server DB instance.
  • The restoration must be from an earlier database version to the same or a later version. The version of local backups must be earlier than or the same as the version of the destination DB instance to be restored.

    For example, if the local database version is Microsoft SQL Server 2012 Standard Edition, you can only restore the local backups to Standard or Enterprise Edition of Microsoft SQL Server 2014 or 2016. You cannot restore the local backups to any versions of Microsoft SQL Server 2008 or Web Editions of Microsoft SQL Server 2014 and 2016.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel